Calculate Elapsed time: difference between 2 Date/Timestamp perio
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?? |
Calculate Elapsed time: difference between 2 Date/Timestamp perio
=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?? |
Calculate Elapsed time: difference between 2 Date/Timestamp perio
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?? |
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?? |
Calculate Elapsed time: difference between 2 Date/Timestamp p
Thanks Bob! This was exactly what I wanted!
"Bob Phillips" wrote: 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?? |
All times are GMT +1. The time now is 03:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com