On 26 Mar 2006, at 20:01, Jonathon Coombes wrote: > =SUM(<C2:C6>)+SUM(<C8:C11>)+SUM(<C15:C25>)
I already tried that, but got the same bizarre results. However, Gene's answer was spot on. The calculation was working fine -- it was simply a formatting issue in the output cell. I had applied standard formatting of HH:MM and it was overflowing every time it got to 24 hours in HH side, resetting the hours to 0. To resolve it the first thing I tried was to put DD: in front of the formatting code. But that didn't give me what I wanted. Ultmately, after poking around the other standard time formats I hit on the following solution: [HH]:MM All is peace and joy now. :) Documentation for the formatting codes would have helped. But thank goodness this list is here! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
