Time (gentlemen, please)
Thanks Pete
--
Traa Dy Liooar
Jock
"Pete_UK" wrote:
Format the cell with the SUM in it using Custom, as [hh]:mm. The
square brackets around the hh tell excel not to wrap hours above 24.
Hope this helps.
Pete
On Aug 14, 4:00 pm, 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?
Thanks
--
Traa Dy Liooar
Jock
|