Struggling with Overtime Calculations for Workers in Excel? Need Your Help!

Dear All,

I am working in a manufacturing company in the payroll department. We have three types of staff: office staff, store staff, and workers. The workers are only entitled to have overtime. Can anybody help me with a formula to calculate the overtime for the workers? I am trying to create a system in Excel to calculate leaves, late attendance, etc., but I am unable to calculate the overtime for the workers. I would be very grateful if anybody could kindly help me out of this situation.

With regards,
Soumi.

Hi,

I've attached one Excel sheet. I hope it'll be useful for you.

Regards,
Suresh N

I would like to be a PF & ESI consultant. Please let me know what I should do in this regard. Currently, I am working in a private company, handling PF and ESI-related tasks independently. :-P