Head Travel Services
Manager Hr & Admn
Entering the attendance in an excel sheet will definitely require some formulas at the time of payroll processing...
Prepare a sheet in an excel sheet with the headers-
1. Employee Code
2. Employee Name
4. Date of Joining
5. Start with the entering 1st 2nd, 3rd and so on till the last date of the month
6. Below the date just mark P for present, A for absent, L for Leave, W for week off and H for Holidays... after filling the data use the formula count if to calculate number of A as well as number of L.. it will be used for the payroll processing..
Hope it has definitely given you a good idea to proceed on..
7th December 2007 From India, Ahmadabad
7th December 2007 From Hong Kong
Attendance register is a statutory document and the requisite information need to be filled to avoid legal problems at the later date. The printed format of attendance details is available in any book shop as per act
and hence you may get one attendance register and start filling the attendance of your office.
14th December 2007 From India, Madras
Iam working as hr executive as unit level in pharma industry in bidar. I would like to maintain all formalities as per the laws. so can u give me suggestions and example copys to maintain a to z activities in unit level
5th June 2008 From India, Pune
Nice to meet you all!
22nd July 2008 From Indonesia, Jakarta