This time calculation is driving me crazy, I have several suggestions,
thank you but they don't work. Try it for your self, Open a blank
sheet, Format all cells as [hh]:mm, in A1 put 06:00, in A2 put 05:00,
in A3 put 07:00, in A4 put 08:00, now B1 put in the formula =A1+A2 & in
B2 put in formula =A3+A4. now put in B3 =B1+B2. It just won't work which
ever way you format the cells, I have worked on this problem for 3 days
now trying every possible combination, I would give my right arm for
the solution. I know this is a 24 hour time calculation but if the
cells you are adding together are results of calculations from other
cells the formula won't work. Try it for your self. PLEASE PLEASE
HELP!!!


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=511332