MS Excel Help: Calculate Amount of Time?

Asked by scula (54

) December 13th, 2009

Does anyone know how to calculate the amount of minutes and seconds between different times in Excel?
For exampl, I want to take a time stamp in this format: 2009–12-09 17:26:34
and then find the elapsed minutes and seconds to the next timestamp: 2009–12-09 17:56:31
What formula do I use? Thanks.

Observing members: 0

Composing members: 0

1 Answer

If your timestamps are in columns A and B, I’d imagine this would do the trick: =B1-A1 and then make sure to set the cell format to time, showing the difference in minutes and seconds.

Just tested with this:
timestamp A: 09/12/2009 17:26:34 (cell format = custom: dd/mm/yyyy hh:mm:ss)
Timestamp B: 09/12/2009 17:56:31 (cell format = custom: dd/mm/yyyy hh:mm:ss)
=B-A: 0:29:57 (cell format = custom: h:mm:ss)

wildflower (11180

)“Great Answer” (5

) Flag as…