General Question

scula's avatar

MS Excel Help: Calculate Amount of Time?

Asked by scula (54points) 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

wildflower's avatar

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)

Answer this question




to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
Knowledge Networking @ Fluther