Re: Time sheet in Excel
you are AMAZING!!!! thank you so very much!! its perfect
Re: Time sheet in Excel
you are AMAZING!!!! thank you so very much!! its perfect
Re: Time sheet in Excel
i cant get the OT to work, i'm going to attached a copy of our actual time sheet so you can see what i ma trying to do. and thank you so much for helping with this
Re: Time sheet in Excel
i posted a spreadsheet of what i need it to look like
Re: Time sheet in Excel
I did and it works but it takes the 16 hours and splits them, 8 in Reg and 8 in OT. i need it to keep the 16 in reg until reg reaches 40 then have it go into the OT
Re: Time sheet in Excel
saY the person has worked
Monday- 7:00-23:00 16 hours
Tuesday 23:00-7:00 8 hours (rolled into another day)
Wednesday 15:00-7:00 16 hours (rolled into another day
Thursday- 7:00-15:00 8 hours
i need it to calculate the total hours for each day worked, regular hours for each day (8) and not add the overtime until the regular has reached 40
Re: Time sheet in Excel
i need to calculate the overtime column to add the hours after they reach 40 from the regular time column.
Hello i am trying to create a formula to calculate overtime in excel, the problem i am having is i need to calculate: total time, Regular Time and Overtime, but the overtime is only after 40 Regular time hours have been reached. i have it to where it will calculate overtime but it does it for any hours worked after 8. i just need after 40. i have a copy of the time sheet attached. thank you!!! need this ASAP!!! ALSO i need to keep the formula in total time to calculate from one day into the next, we work 24/7 365 so we can go from one day into the next on the same shift.