Calculate Elapsed time: difference between 2 Date/Timestamp perio

B

beadedbeauty

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

Bob Phillips

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

--
HTH

Bob Phillips

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

beadedbeauty

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

Toppers said:
=B1-A1

format cell as Custom==>[h]:mm

B1 = End date, A1 = Start Date

beadedbeauty said:
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??
 
B

beadedbeauty

Thanks Bob! This was exactly what I wanted!

Bob Phillips said:
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 said:
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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top