If you want to see the total number of hours, you'll need to change a couple
of equations and formats.
First change the formats for B1-B3 to NUMBER.
B1: =(A1+A2)*24
B2: =(A3+A4)*24


"Chris Watson"
wrote in message
news:Chris.Watson.232j2m_1139667003.4289@excelforu m-nospam.com...

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