Currently, I am working in a manufacturing company where many temporary workers are employed, and their salary is based on daily wages. It is challenging to manually calculate their working hours. I kindly request your assistance in providing a formula in Excel that would facilitate an easier calculation process.
Regards,
Minal Shah
From India, Vadodara
Acknowledge(0)
Amend(0)
2Regards,
Minal Shah
From India, Vadodara
Acknowledge(0)Amend(0)
Hi, Please find herewith sample pay sheet for your ready reference.
From India, Kolhapur
Acknowledge(0)Amend(0)
From India, Kolhapur
Acknowledge(0)Amend(0)
dear sir, i required formula for counting of hours. not for wages calculation. (daily hrs diff. between in time and out time.)
From India, Vadodara
Acknowledge(1)Amend(0)
From India, Vadodara
Acknowledge(1)Amend(0)
Minahshah, take a register first to note the in-time and out-time. With that, you can calculate the daily hours, which should be 8 hours. The amount by hours (8) gives the per-hour rate, and with that, you can pay for the worked hours.
Regards,
Srihari
From India, Hyderabad
Acknowledge(0)Amend(0)
Regards,
Srihari
From India, Hyderabad
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.
EXCEL FORMULA.xls