hours not adding-help

  • Thread starter Thread starter kgs
  • Start date Start date
K

kgs

Excel 97
I am trying to add column of times (see below) but keep getting 0:00:00. Can
anyone tell me what the problem is by looking at this? Any help would be
greatly appreciated.
Thanks in advance.
Geo.

30:30
49:20
30:22
20:58
10:55
23:30
31:40
40:50
00:00.0 total???
 
Sorry - should have read the subject line again:

Format/Cells/Number/Custom [h]:mm:ss.0
 
I get 238:05

Are you sure they are being stored as time serials. If you select the cells
and do Format=>General, do they look like this:
1.270833333
2.055555556
1.265277778
0.873611111
0.454861111
0.979166667
1.319444444
1.701388889

If not, then they are not being stored as time serial values.
 
30:30:00
49:20:00
30:22:00
20:58
10:55
23:30
31:40:00
40:50:00
238:05:00

Just select your column of figures, press formula button,
and it adds -- won't break down into hours though unless
you divide total by 60.
 
Not sure about 97, try formating cells as [h]:mm, this in later versions
allows the hours to calculate over 24
 
Since almost all his hours are over 24 - I think he might already be
formatted that way. However, maybe these are minutes.

[h]:mm should work in all versions as least as far back as xl5 and probably
earlier.
 
Back
Top