Time (gentlemen, please)
"Jock" wrote...
I'm trying to add up a column of times (format/custom hh:mm) however,
when 24 hours is reached and exceeded, the results start at 00:00 again
rather than just continuing to add up. How can I get around this?
Give that cell the number format "[h]:mm:ss". The seconds portion is
optional, but the hour portion needs the square brackets.
|