autosum time

S

Shu of AZ

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
 
F

Fred Smith

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.
 
S

Shu of AZ

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
 
B

Bob Phillips

Format your totals cell as [h]:mm

--
---
HTH

Bob


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