I am trying to calculate a time sheet but I entered: =SUM(C4-D4)+(E4-F4)
and I get a negative # for the total?! Can someone help me on this?
Also, I want to convert my time to military time so when I type in a
time it will automatically convert? My time sheets looks as follows

TIME IN TIME OUT TIME IN TIME OUT TOTAL
8:45 AM 12:30 1:00 4:00 PM =SUM(C4-D4)+(E4-F4)
8:45 AM 1:30 2:00 5:00 PM =SUM(C5-D5)+(E5-F5)

TOTAL HOURS WORKED


--
smiller3128
------------------------------------------------------------------------
smiller3128's Profile: http://www.excelforum.com/member.php...o&userid=25929
View this thread: http://www.excelforum.com/showthread...hreadid=393022