Thread: autosum time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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