Dear All Seniors,
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)
2Currently, 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)
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(0)Amend(0)
From India, Vadodara
Acknowledge(0)Amend(0)
Minahshah,
Take a register first to note the in time and the 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)
Take a register first to note the in time and the 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)
Dear Minal, Yes I agree with views expressed by Mr. Srihari, you can go for that
From India, Kolhapur
Acknowledge(0)Amend(0)
From India, Kolhapur
Acknowledge(0)Amend(0)
Dear All,
There are various means to count daily wage workers' attendance. Firstly, keep a register at the main gate of the factory and record their attendance for 8 hours. The IN and OUT entries must be there and should be countersigned by the security supervisor and the HR person nominated for the specific task.
The second way to start counting is on a PC and attendance machines, which are nowadays being used all over the country. The programs are so well-set that there is hardly a choice left for manipulations. You can issue temporary smart cards for them, and after 89 days, they should be changed regularly. It is very easy to get it done.
The only questions that are not clear in my mind are:
(a) What is the size of your company?
(b) How many temporary workers are being employed?
(c) What is the annual turnover of your company?
(d) Are you employing security services?
(e) Are you using the latest attendance monitoring system or not?
May I request you to kindly be very specific while posing questions so that you will get correct and logical answers, please.
Col (Retd) VP Karad
9890245732
From India, Pune
Acknowledge(0)Amend(0)
There are various means to count daily wage workers' attendance. Firstly, keep a register at the main gate of the factory and record their attendance for 8 hours. The IN and OUT entries must be there and should be countersigned by the security supervisor and the HR person nominated for the specific task.
The second way to start counting is on a PC and attendance machines, which are nowadays being used all over the country. The programs are so well-set that there is hardly a choice left for manipulations. You can issue temporary smart cards for them, and after 89 days, they should be changed regularly. It is very easy to get it done.
The only questions that are not clear in my mind are:
(a) What is the size of your company?
(b) How many temporary workers are being employed?
(c) What is the annual turnover of your company?
(d) Are you employing security services?
(e) Are you using the latest attendance monitoring system or not?
May I request you to kindly be very specific while posing questions so that you will get correct and logical answers, please.
Col (Retd) VP Karad
9890245732
From India, Pune
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.