The HH:MM function

C

Chris01623

Im making a spreadsheet which caluclates how much training certain people
have done in hours.
For instance on one day someone may do 10 hours 30mins (represented in the
spreadsheet as 10:30) and for the next four days did the same. What i would
like is a number in my total column like this 52 hours 30mins (52:30) however
the "total" cell wont exceed over 24:00, im sure its supposed not to exceed
that because of the hh:mm function im using, but i wondered if anyone could
tell me a way around this?
Thanks
 
J

Jon Quixley

Chris,

Format all the cells you intend to use as time format in the following
manner:

[hh]:mm

To do this pull down Format/Cells/Custom and enter into the TYPE box
the format above INCLUDE THE SQUARE BRACKETS AROUND THE HH

This will express all time as hours regardless of whether it is less
than 24 hours or not

Cheers
Jon
 
Top