Forum Discussion
Solved
Please help me to set up a wage book. I need formula to calcuate overtime,
I am in need of formula to calculate overtime. At times employees work for more then 26 days, I have attached a table in excel sheet, for reference. please help at the earliest.
Reworked your formulae by introducing the MIN function. Please see the bottom part in the attached workbook. Furthermore, I made the formulae more dynamic by removing hard coded variables, Like max daily rate, base percentage and standard number of days. You'll find them above the table.
Reworked your formulae by introducing the MIN function. Please see the bottom part in the attached workbook. Furthermore, I made the formulae more dynamic by removing hard coded variables, Like max daily rate, base percentage and standard number of days. You'll find them above the table.
Sir,
I am very grateful for your quick response, your help is much appreciated. thanks and God Bless
Ronald Pinto