Forum Discussion
EXCEL HELP
Hello, I'm making a timesheet to help my employees accurately claim the correct amount of overtime/penalty rates. As you can see above this is a normal start/finish time with a meal break and ...
Hi Drysie, you can do it including couple of parameters and following formula in K10
Parameters to determine hours at 150% and 200%. Last parameter is a unit of measure to calculate(1 hr).
In k10 you can include this formula : =IF(J5-I15>0;+ROUND((J5-I15)/K15;2)&" of 150"; "")
The IF validate if you have more than 8 hours. Alfter that, calculate over time in minutes and compare with unit of measure to get a 0.5 corresponding to 30 minutes.
Please let me know if it works for you.
Regards
https://www.upwork.com/freelancers/~01cf0fc8446b00f44c