Time (gentlemen, please)

[Guest]

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

 

[Pete_UK]

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

 

[Harlan Grove]

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.

 

[Guest]

Thanks Pete
--
Traa Dy Liooar

Jock

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

 

[Pete_UK]

You're welcome, thanks for feeding back.

Pete

Thanks Pete
--
Traa Dy Liooar

Jock

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.

- Show quoted text -

 

[Ron Rosenfeld]

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

Format/Cells/Number Custom Type: [hh]:mm


--ron