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
|