Time/ Number format on excel file exported from Access

J

Joe

I receive a spreadsheet that is created by an export from access.
One of the columns is a time/date column
and is displayed as:

0.359722222
1.818055556

I need to return a format in hh:mm

Given the two numbers above, I need the following:
0.359722222 - this is 8 hours and 38 minutes(.3597 of a day), I need 8:38
to display
1.818055556 - this is 43 hours and 38 minutes(1.81 days). I need it to
display 43:38

Changing the number format to h:mmonly works if the number of hours are less
than 24.

I am using excel 2003

Thanks
 
R

Richard

Goto custom format and try [h]:mm

The [ ] around the h will allow it to go over 24 hours.
 
Top