I have a time sheet that I seriously need help on. I've kind of got it but it just isn't right and it isn't doing what I wanted it to do.
I don't mind if it is VBA or formula I just need it to calculate right.
Here's what I got.
I have a timesheet that tracks the time an employee clocks in, out, and how long they take for lunch. I also track how long they work on a job and this tracked in many places other than the time sheet itself. This is all tracked Mon-Sun and ran back to another worksheet called "mainpage". At this point it really isn't important, I just need the math to come out right.
Attached is a copy of one of the time sheets adjusted with the correct numbers so that it doesn't try to refer back to my original spreadsheet.
Download Timesheet
okay so in column C14:C40 it tracks the # of hours the employee spent on each job and totals them in C43. However this employee can only work a regular 8 hours and anything over that is considered overtime. So if he works 10 hours on Monday then he has earned 8 regular hours and 2 overtime hours.
This goes on all the way through Sunday however,
1. The week doesn't always start on Monday, and
2. Once the employee has hit 40 regular hours all additional time is considered overtime.
I need the time sheet to display the # of regular hours and the # of overtime hours for each day and then have it also show me at the end of the timesheet such as "total regular hours and total OT hours".
I also have a section for the ability to add comp hours that don't actually add to the "timesheet" but it does add to his total hours for payment. You can see how I calculated all this once you DL the SS but the way it is bothers me cause it isn't 100% correct.
Any and all help is welcomed and VERY appreciated. I've been working on this for over a year and I must have changed it a dozen times. I just can't keep trying to figure it out alone.
I don't mind if it is VBA or formula I just need it to calculate right.
Here's what I got.
I have a timesheet that tracks the time an employee clocks in, out, and how long they take for lunch. I also track how long they work on a job and this tracked in many places other than the time sheet itself. This is all tracked Mon-Sun and ran back to another worksheet called "mainpage". At this point it really isn't important, I just need the math to come out right.
Attached is a copy of one of the time sheets adjusted with the correct numbers so that it doesn't try to refer back to my original spreadsheet.
Download Timesheet
okay so in column C14:C40 it tracks the # of hours the employee spent on each job and totals them in C43. However this employee can only work a regular 8 hours and anything over that is considered overtime. So if he works 10 hours on Monday then he has earned 8 regular hours and 2 overtime hours.
This goes on all the way through Sunday however,
1. The week doesn't always start on Monday, and
2. Once the employee has hit 40 regular hours all additional time is considered overtime.
I need the time sheet to display the # of regular hours and the # of overtime hours for each day and then have it also show me at the end of the timesheet such as "total regular hours and total OT hours".
I also have a section for the ability to add comp hours that don't actually add to the "timesheet" but it does add to his total hours for payment. You can see how I calculated all this once you DL the SS but the way it is bothers me cause it isn't 100% correct.
Any and all help is welcomed and VERY appreciated. I've been working on this for over a year and I must have changed it a dozen times. I just can't keep trying to figure it out alone.
