View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Difference between 2 times

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?