autosum time
 

This is a reduced example of the complete column and all cells are formatted
HH:MM and this will not autosum. The total does not go over 99 hours. Any
explanation would be helpful

00:32
00:27
00:13
00:20
00:26
00:06

00:00 This is the result

autosum time
 

One of three things could be happening:

1. You have text rather than actual Excel times in your cells.
2. Your recalculation is set to manual.
3. The autosum is picking up the wrong cells to total (likely because you
have a blank line between the last cell and the total).

Post back if you need more help after checking these items. Be sure to post
the formula in your result cell.

Regards,
Fred.

"Shu of AZ" wrote in message
...
This is a reduced example of the complete column and all cells are
formatted
HH:MM and this will not autosum. The total does not go over 99 hours.
Any
explanation would be helpful

00:32
00:27
00:13
00:20
00:26
00:06

00:00 This is the result

autosum time
 

05:25
05:49
02:50
06:04
06:15

02:23 This is the total
=SUM(G2:G114)
No text formats
10 blank cells between each HH:MM

"Fred Smith" wrote:

One of three things could be happening:

1. You have text rather than actual Excel times in your cells.
2. Your recalculation is set to manual.
3. The autosum is picking up the wrong cells to total (likely because you
have a blank line between the last cell and the total).

Post back if you need more help after checking these items. Be sure to post
the formula in your result cell.

Regards,
Fred.

"Shu of AZ" wrote in message
...
This is a reduced example of the complete column and all cells are
formatted
HH:MM and this will not autosum. The total does not go over 99 hours.
Any
explanation would be helpful

00:32
00:27
00:13
00:20
00:26
00:06

00:00 This is the result

autosum time
 

Format your totals cell as [h]:mm

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Shu of AZ" wrote in message
...
05:25
05:49
02:50
06:04
06:15

02:23 This is the total
=SUM(G2:G114)
No text formats
10 blank cells between each HH:MM

"Fred Smith" wrote:

One of three things could be happening:

1. You have text rather than actual Excel times in your cells.
2. Your recalculation is set to manual.
3. The autosum is picking up the wrong cells to total (likely because you
have a blank line between the last cell and the total).

Post back if you need more help after checking these items. Be sure to
post
the formula in your result cell.

Regards,
Fred.

"Shu of AZ" wrote in message
...
This is a reduced example of the complete column and all cells are
formatted
HH:MM and this will not autosum. The total does not go over 99 hours.
Any
explanation would be helpful

00:32
00:27
00:13
00:20
00:26
00:06

00:00 This is the result