You don't need all the SUMs. Try this:

For Actual Hours:
=((C12-C11)+(C10-C9))*24

For Flex Hours:
=(B19-B18)*24

For Total:
=B20+B13

Format All of the totals as General. Your answer will be 7.5.


You could also eliminate all of the "*24"s and format everything as
time and
your answer will be 7:30


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=540370