Forum Discussion
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.
2 Replies
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
