Hi,
In my time report I have Start Time, Finish Time, Lunch Time, Total and Overtime Hours. Because I work nights, I am using the MOD command to calculate the worked hours which boils down to Start Time - Finish Time - Lunch Time.
The problem I have is that we are paid extra time from 8pm to 6 am. Is there an easy way to get the spreadsheet to calculate the hours between the Start Time minus the Lunch Time upto 06:00?
Everything I have tried just dosnt work.
I have attached a copy of of my Time Report so you can see what I am talking about.
Thanks in advance
Alan
Bookmarks