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?