Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time calculations and additional 24 hour days
I am tring to calculate the amount of time passed over several days. I have
the start time on one day and the end time several days later. The dates are stored in a seperate column from the times. I can calculate the time and I can calculate the days passed. The format for the date returns a number (either 2 for days or 48 for hours) but the time is in 00:00 format. I need the total amount of time in either 00:00 or (0.00 prefered) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time calculations and additional 24 hour days
If you multiply a time value by 24 and format the result as a number (rather
than a time), you'll get the number of hours. "Mark G" wrote: I am tring to calculate the amount of time passed over several days. I have the start time on one day and the end time several days later. The dates are stored in a seperate column from the times. I can calculate the time and I can calculate the days passed. The format for the date returns a number (either 2 for days or 48 for hours) but the time is in 00:00 format. I need the total amount of time in either 00:00 or (0.00 prefered) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time calculations and additional 24 hour days
Use custom format [h]:mm
-- Regards, Peo Sjoblom "Mark G" <Mark wrote in message ... I am tring to calculate the amount of time passed over several days. I have the start time on one day and the end time several days later. The dates are stored in a seperate column from the times. I can calculate the time and I can calculate the days passed. The format for the date returns a number (either 2 for days or 48 for hours) but the time is in 00:00 format. I need the total amount of time in either 00:00 or (0.00 prefered) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|