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