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?

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

"Mike H." wrote in message ...
| 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?

In article ,
"Niek Otten" wrote:

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.

--
David J Richardson --
http://davidj.richardson.name/ - Dr Who articles/interviews/reviews
http://www.boomerang.org.au/ - Boomerang Association of Australia