Struggling with Daily Wage Calculations for Temp Workers? Seeking Excel Formula Help

minalshah4797
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
V.B.Patil
Please find attached the sample paysheet for your reference. 

Thank you.
1 Attachment(s) [Login To View]

minalshah4797
I require a formula for counting hours, not for wage calculation. Specifically, I need to calculate the daily hours difference between the in-time and out-time.

Thank you.
srihari2720
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
vishwanadh9999
If you have time in the office, you can do it like this. Please find the Attendance card format attached. It may help you out.

Regards,
Viswanadh
[Phone Number Removed For Privacy Reasons]
1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute