Hours format

[garcost]

I have a file that I want to load into Access and I can't figure out one of the columns. The column in question is suppose to display an amount in hours. Ie. 84:08:00. Which it does, but when I click on the cell I see a date and time format. Ie. 1/3/1900 12:08:00 PM.

If I try to load the file into Access it loads the data in the date and time format. I really want to see 84:08. Can anyone explain how I can convert the data, and how is Excel reading the data this way.

Many thanks.

GC

 

[barry houdini]

I don't know about Access but because Excel's calendar starts at 1st January 1900

1/3/1900 12:08:00 PM

represents 3 days, 12 hours and 8 mins, i.e. your original 84:08

In Excel you could simply reformat a cell showing

1/3/1900 12:08:00 PM

with a custom format of [h]:mm and it will display 84:08, can you do the same in access?