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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top