Overtime for 8 hour and 40 hour
Need help on how to do calculate formula when using 8 hour and 40 hour
overtime rule. What I am doing is try to build spreadsheet for tracking of working hours on regular hour, days off with pay and overtime, below is example of what it looks like: A B C D E F G H I 1 Hour Type MON Tues Wed Thur Fri Sat Sun Total 2 DayOff 0 0 8 15 14 0 0 37 3 Regular 14 15 0 0 0 17 12 58 4 Overtime ? ? ? ? ? ? ? 0 On days off employee gets time off with pay, if employee works on that day off and works over 8 hours it falls into 8 hour rule overtime for each day. If he works on regular work days he has to work 40 hours before start getting the overtime. I have to use both 40 and 8 hour overtime, question is how do you use formula to work with both 40 and 8 hour in roll 4 for overtime? |
Overtime for 8 hour and 40 hour
In your example, would employee get 18 hours "Regular Overtime" (58-40) PLUS
13 hours "Day off" overtime [ (15-8 )+(14-8)]? "Curtis" wrote in message ... Need help on how to do calculate formula when using 8 hour and 40 hour overtime rule. What I am doing is try to build spreadsheet for tracking of working hours on regular hour, days off with pay and overtime, below is example of what it looks like: A B C D E F G H I 1 Hour Type MON Tues Wed Thur Fri Sat Sun Total 2 DayOff 0 0 8 15 14 0 0 37 3 Regular 14 15 0 0 0 17 12 58 4 Overtime ? ? ? ? ? ? ? 0 On days off employee gets time off with pay, if employee works on that day off and works over 8 hours it falls into 8 hour rule overtime for each day. If he works on regular work days he has to work 40 hours before start getting the overtime. I have to use both 40 and 8 hour overtime, question is how do you use formula to work with both 40 and 8 hour in roll 4 for overtime? |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com