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)

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)

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)