Adding hours

  • Thread starter Thread starter Sharon Swartz
  • Start date Start date
S

Sharon Swartz

Hello!

I am desperately trying to get a total =SUM(==) of a
column of hours. I cannot get it to give me a correct
total and can find nothing in the HELP file. The columns
are formatted as Time - hh:mm.

The colum total is shown as 17:00, but the actual total is
47:00.

I would really appreciate some pointers!

Shaz
 
Use custom format [hh]:mm

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Unless you specify a different format, XL will "roll over" the hours
after 24. Try:

Format/Cells/Number/Custom [hh]:mm


the brackets will prevent the rollover.
 
Back
Top