creating simple monthly work schedule for 6 employees but need to tally hours...

I think this is simple, but I cannot figure this out!

Maybe it is the layout but I was trying to keep it simple and just put hours into a cell for each employee.
I have 2 employees per day, one in the morning and one in the evening. I need advice on how to get excel to add the hours for each employee at the bottom per month. Simple right?

Here is an example of what I thought would be so easy (first week in excel spreadsheet format)

sun mon tue wed thu fri sat
emp1 5 emp3 6 emp5 5 emp1 4 emp3 5 emp5 5 emp1 6
emp2 5 emp4 5 emp6 5 emp2 5 emp4 5 emp6 6 emp2 6

Is there a way to associate cells to look at values for each employee and add all the cells for the month?

Thanks,

Thomas

Hi

How long is each shift and what happens if they are late or leave early?

Sorry I was trying to do a visual monthly schedule of each employee and hours they worked per day. But if I am understanding you correctly, go with a vertical seperate spreadsheet instead?

each shift is only 4-6 hours long. i let the employees decide how fast they can complete the job. they just send me an email of the hours worked and i cut them a check.