Subtract the earlier from the later, and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"beadedbeauty" wrote in message
...
I need to calculate the elapsed time between 2 dates/timestamps. For ex.,
I
need to get the elapsed time in hh:mm between:
8/20/2006 08:00:00 (hh:mm:ss) AND 8/21/2006 09:00:00. The answer would be
25 hours in this case. How do I do this in Excel 2000??