Dear All Seniors,
currently i am working in manufacturing company, here there are many temporary workers are working and their salary is on daily wages. so its very tough to count working hrs on manually.
so kindly help me to give any formula in excel so i can count easily.
regards,
Minal Shah

From India, Vadodara
Anonymous
50

Hi, Please find herewith sample pay sheet for your ready reference.
From India, Kolhapur
Attached Files (Download Requires Membership)
File Type: xls Paysheet _Oct.xls (47.5 KB, 1066 views)

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
minahshah
take a register first note the in time and the out time and with that u get the daily hours that means 8hrs..
the amount by hours(8) gives per hour rate with that u can pay for the worked hours.. ..
regds
srihari

From India, Hyderabad
Anonymous
50

Dear Minal, Yes I agree with views expressed by Mr. Srihari, you can go for that
From India, Kolhapur
Dear All,

There are various means to count daily wages workers attendance. Firstly keep a register at Main gate of the factory and take their attendance for 8 hours. The IN and OUT entry must be there and it should be countersigned by security supervisor and HR person nominated for the specific task.

The second way to start counting is on PC and attendance machines which are nowadays being used all over the country. The programs are so well set that there is hardly choice is 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 which 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 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
Dear Minal, If you have time office, you can do like this, please find out this Attendance card format. It may help you out. Regards, Viswanadh 9676929991
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Attendance card-Viswanadh.xls (19.5 KB, 760 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.