Hiya,
I'm trying to add up a column of hours, however I'm finding because I'm using a date format (hh:mm:ss), it won't total past 24 hours.
For example, if I add together 12:30:00 and 12:30:00 I should get 25:00:00, however I get 01:00:00.
Is there some way I can correctly add together a long list of hours? I assume something needs to be added to the sum formula.
I'd appreciate anyone's help.
sooz
I'm trying to add up a column of hours, however I'm finding because I'm using a date format (hh:mm:ss), it won't total past 24 hours.
For example, if I add together 12:30:00 and 12:30:00 I should get 25:00:00, however I get 01:00:00.
Is there some way I can correctly add together a long list of hours? I assume something needs to be added to the sum formula.
I'd appreciate anyone's help.
sooz