Need Solutions - Xls Download

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

Hi,
Please find herewith sample pay sheet for your ready reference.

dear sir,
i required formula for counting of hours. not for wages calculation. (daily hrs diff. between in time and out time.)

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

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

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

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