I have this set up pretty basically, I believe. Column C are the days of the week, Column D is the date, Column E is the time clocked in, Column F is the time clocked out and Column G are the total hours worked for that day. In G18, I've set up (or so I think) the formula to calculate this employees total hours for the work week =(G4+G6+G8+G10+G12+G14+G16). As of now, my employee has worked 32 hours but it is showing only 7 hours total. Our work week runs from Sunday to Saturday and not all of the employees work the weekends. This employee did not work Sunday and after reading another discussion question, I've come to realize that the time in and time out for Sunday cannot just be blank. If that is the reason for my error in total hours, what formula or word or WHATEVER can I type in to make the value 0?

(I thought a visual may help)

-----C-----D-----E-----F-----G-----
Sunday 1-Nov

MsMollie

Whoops! Still new to this lol One more time!


-----C------D------E------F------G------
Sunday 1-Nov 0:00
Monday 2-Nov 9:00 4:00 7:00
Tuesday 3-Nov 5:30 1:30 8:00
Wed 4-Nov 7:30 5:30 10:00
Thurs 5-Nov 7:00 1:00 6:00
Friday 6-Nov 0:00
Sat 7-Nov 0:00
Total hours: 7:00

JBeaucaire

Be sure to enter time in E and F as actual time values, including the AM/PM values so they get cacl'd properly.

Then the G1 formula is:
=(F1-E1) * 24
...formatted as General. Copy that down.

The total in G8 is simply:
=SUM(G1:G7)

By converting the values in column G back to standard decimal values, the TOTAL is easier.

Attached Files

SampleTime.xls (13.0 KB, 10 views)