Setting up a Timesheet for workers with overtime.

[tommygoesha]

Hello everyone my name is Tom. I just started as an assistant for a fairly large group of people.
I've fiddled with Google docs a bit but Excel is a whole nother monster this is my first project I've done on excel.

I have a few question I am kind of time sensitive so Instead of researching I was hoping someone would be able to give me some simplified answers.

1) How can I fix the problem with trying to substitute an empty cell in designated areas for 0. I know you can do sum but the cell is also calculated for overtime so right now all i have is substitute " " (space) for 0 wich is kind of annoying. I want the option to put # of hours or S for sick etc. etc..
(Bonus?: It'd be nice if I found a way to add up all the S and V and L on the main expenses table)

2) Is there a way setup that when they come "IN" to work if its after 6am it will put "tardy" in status area then it will copy that incident to another sheet. I'm trying to get everything as automative as possible.

3) I have no idea how I will do this but I wanted to kind of mark people as either journeyman\apprentice\etc and it will add up all journeymen hours to another sheet, or all apprentice hours to another sheet.

My goal is to just have a spreadsheet of mostly everything I need to know about each individual person along as well as them all added up. I saw an attendance record

Any tips and help is GREATLY appreciated! Thank you for atleast giving me your time to read thus far.

I attached a demo without anyone's names if you want a example.



EDIT:

Using the formula that I suggested to enter the 'Tardy' comment in the status column, you could use

=COUNTIF(December!I16:AC178,"tardy")

to count all instances of 'Tardy' on the sheet, but without some completed (fictional) data, names, etc on the sample, I don't know what will be going where to count occurrences by name.

Alright I've attached a sort of demo. Its for an electricians team and Each person is either a Material hander, Apprentice or Journeyman.
What I hope to achieve Is entering the most minimal amount of data wich will calculate\automate everything else. While also having a simplified summary version for the boss.
What Im trying to do is find some way to mark people as Apprentice or Journeyman so that their overtime\normal hours gets categories into the correct spot on Sheet: Hours and Expenses Table.
I have also attached an Attendance Record DEMO that I used for a very short period of time. The only problem with it is I cant calculate overtime and I cant put specific hours (for when they are tardy)
I may just be over thinking it - But any tips\tricks or suggestions would be greatly appreciated.Attachment 437396 Attachment 437401

Edit: I love how simple the Attendance Record DEMO is but again I cant put hours. I was brain storming and maybe I could make some sort of way that it will put a list of all Tardies on a seperate sheet maybe so when I put L I can put on that other sheet what exactly the time they came in at.