You're welcome, thanks for feeding back.

Pete

On Aug 14, 4:22 pm, Jock wrote:
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- Hide quoted text -

- Show quoted text -