Time (gentlemen, please)
 

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

Time (gentlemen, please)
 

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

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.

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

Time (gentlemen, please)
 

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 -

Time (gentlemen, please)
 

On Tue, 14 Aug 2007 08:00:06 -0700, 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

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


--ron