Difference between 2 times

[Mike H.]

How do I calculate the difference between two times:

11:14:56 AM
11:06:41 AM

I want to know hours, minutes and seconds between the two times shown as

0h 8m 15sec or some way similar to that. I think I could do this
calculation with a very long complex formula but is there a simple way to
calculate elapsed time?

 

[Niek Otten]

Just subtract one from the other and format the result in some time format that doesn't give you the AM/PM

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I calculate the difference between two times:
|
| 11:14:56 AM
| 11:06:41 AM
|
| I want to know hours, minutes and seconds between the two times shown as
|
| 0h 8m 15sec or some way similar to that. I think I could do this
| calculation with a very long complex formula but is there a simple way to
| calculate elapsed time?

 

[David J Richardson]

Just subtract one from the other and format the result in some time
format that doesn't give you the AM/PM

But be cautious doing comparisons between the difference and another
value (ie. was the difference less than or equal to 3 minutes 20
seconds?). You'll almost certainly have an answer of the form
19.99999975632 or 20.00000018463 seconds.