On Sunday 26 March 2006 11:40, John Jordan wrote: >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.
Thanks for the flowers. > 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. > And then starting over. >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! Well, I could see from the results that the HH: had a 0-23 range, and that the carryover into the next day was being tossed out, but like you, had no clue as to how to fix it. I'm glad that helped, and that you posted back that it did. Thank you. Just to clarify, is it now possible to get answers in the [HH] format that will reach to 99 before the overflow now? What happens if you use [HHH]:DD instead in that event? In case someone wanted a YY/MM/DD HH:MM:SS format, I wonder how thats accomplished? -- Cheers, Gene People having trouble with vz bouncing email to me should add the word 'online' between the 'verizon', and the dot which bypasses vz's stupid bounce rules. I do use spamassassin too. :-) Yahoo.com and AOL/TW attorneys please note, additions to the above message by Gene Heskett are: Copyright 2006 by Maurice Eugene Heskett, all rights reserved. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
