Time format question

[frustrated]

Hi All

I would like to undestand why I am getting a different result in excel based upon the time format. I have attached an image of my spreadsheet and also the excel file so you can see what I mean.

img.JPG

Sounds simple right....that's what I thought but can't seem to figure out what's happening.

Thanks for your help.

Time example.xls

[JBeaucaire]

The actual number in E11 is 9.26458333304618
(change to General format to see that)

Each whole number represents a full day to Excel in "date formatting". So 1 = 1 day, 2 = 2 days, etc. So that number represents 9 days plus a fraction of a day.

The [h]:mm Time format represent all days as a count of the HOURS. So 9 days = 9x24, plus the fraction of a day, = 222 hours and 21 minutes.

[frustrated]

Hi JBeaucaire

Thanks for your reply. I do not understand why I get a result of 06:21 when the hh:mm format and 221:21 when using the [hh]:mm format.

Surely I should return the same results using either format?

[shg]

h:mm gives the time (the residual portion of a day). The square brackets around the h instead displays total hours. Likewise, [m] would show total minutes, and [s] total seconds.

[JBeaucaire]

If you now understand fully the difference between [h] (includes days) and h (ignores days), please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.