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.
|