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.

From India, Gurgaon
Acknowledge(0)
Amend(0)

Hi I’ve attached one excel sheet, i hope it’l useful for you. Regards Suresh N
From India, Madras
Attached Files (Download Requires Membership)
File Type: xls book1_206.xls (20.5 KB, 4955 views)

Acknowledge(0)
Amend(0)

i would like to be a pf & esi consultant. please let me know what should I do in this respect. at present i am working in a private concern and doing pf and esi related job independently. :-P
From India, Calcutta
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.