How to calculate overtime on Timesheet after 10 hours per day AND/OR 44 hours per week
Requirement: To add up all the hours in the day based on the times the employee inputs onto their timesheet. Then to give the weekly total at the bottom. However after 10 hours in any one single day (shift) it needs to move any additional hours into the overtime column to count towards the weekly overtime. Also after 44 hours in the week it needs to move any hours over the 44 weekly total into overtime.
Solution:
J4 =IF(H4>10,H4-10,0)
Obtained from the OzGrid Help Forum.
Solution provided by pike
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to count weekdays in a month excluding holidays |
| How to get a specific date when you enter any other dates for the week |
| How to use calendar form control - only allow weekdays to be selected |
| How to get Monday's date when you enter any other date for the week |
| How to create VBA code for a workbook to work on week days only and specific range of time |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
