Time Sheets

[smiller3128]

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

 

[Kassie]

Hi

You are doing your sums incorrectly. Change your formula to read
=(D4-C4)+(F4-E4)

Format your cells as hh:mm, and use 24 hour times, iso 12 hour times. Your
example will then read:

TIME IN: 08:45 and 08:45
TIME OUT: 12:30 and 13:30
TIME IN: 13:00 and 14:00
TIME OUT: 16:00 and 17:00

It would be easier to insert the time in 24 hour format, rather than to
convert. All you do is add 12 to times later than 12 noon. So 1PM = 1 + 12
= 13 and so on