I am trying to enter correct formula for T.I.L. hours on Timesheet that contains see below. Please find Excel worksheet attached. Please refer to green highlights in the attachment which includes for your information and it explains how it works.
"Normal Operating Hours" 8.00am to 6.00pm Monday to Friday.
"Normal Start and Finish Times" 9.00am to 5.06pm
"Ordinary hours" 38 hours per week
"Length of an Ordinatory working day" 7.36 hours or 7.6 hours in decimal plus an unpaid 30 minute meal break
"Meal and Rest break" Employees will not be required to work more than 5 hours without an unpaid meal beak of at least 30 minutes duration
1.5 hours of TIL for each of the first 2 hours of overtime worked then 2 hours of TIL for every overtime hour worked (Monday - Saturday)
For time worked on Sunday 2 hours of TIL for every hour worked
Thanks.
Bookmarks