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

--
[email protected]ve_2nd_at. Randburg, Gauteng, South Africa


"smiller3128" wrote:

>
> 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
>
>