View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How do I find elapsed time between 2 dates and times?

=A2-A1

where A2 is end time and A1 is start time, then format result custom as
[hh]:mm

--
Regards,

Peo Sjoblom


"Alistair" wrote in message
...
I am using Excel 2003. I have a date and time, each in its own column. I
also have another date and time, each in its own column. I need to find
the
exact elapsed time between the two date/time sets, and most of the time,
the
elapsed time is over 24 hours. How do I write the formula to give me the
exact elapsed time?

Thank you for any help you can give.