overtime hours

Hi I am needing help to create a formula within my timesheet tracking spreadsheet to track the number of hours my team have worked during a working week to assist our accounts department to ensure they are receiving the correct pay. Our working week is Monday to Friday and we work 8 hours per...

Hi, A formula help is needed to return a result for columns E and F based on start and finish times specified in columns C and D. In actual working days, the OT01 hours should be calculated below the finish time at 9 PM. The OT02 is calculated after 9 PM and the total number of hours spent on...

Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck! They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day. Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be...

Hello, I need some advise please - I'm at a loss. I need to find overtime hours worked based on a 40 hour working week. I have done preliminary research and most of the formulas online I found do not work for me because of my large data set and the way the spreadsheet is set up. The below...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi Guys! Good day! I need to adappt the formulas from Barry Houdini to work with two shifts, with a rest interval, being the rest during the day or during the night. Overtime is...

Hi, I have a timesheet where the user enters start and end time for each day. The calculated cell below gives the difference between start and end time i.e. number of hours worked. I want to split the hours worked into Normal Hours and Overtime Hours. For Normal Hours I am using...

I have created a timesheet that shows overtime options. I will try to make a copy (can we upload a copy of our file?) I have created checkbox for daily and weekly overtime options. If Daily (True), OT is calculated over 12 hours, if Weekly (True, OT is also calculated over 48 hours per week)...