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)