View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
beadedbeauty beadedbeauty is offline
external usenet poster
 
Posts: 4
Default Calculate Elapsed time: difference between 2 Date/Timestamp p

Thank you so much....I was doing a lot more and it wasn't working!!

"Toppers" wrote:

=B1-A1

format cell as Custom==[h]:mm

B1 = End date, A1 = Start Date

"beadedbeauty" wrote:

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