Hi, I newly joined in a company.They are entering attendance manually in an Excel sheet, using some formulas.In that I found all mistakes, the HR gave me a job to prepare a good Attendance sheet in excel only. Friends plz help me in this issue and forward me the best method for the attendance.
Thanks & Regards,
Sunitha.
From Hong Kong
Thanks & Regards,
Sunitha.
From Hong Kong
Hi Sunitha,
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
3. Designation
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..
Regards,
Amit Seth.
From India, Ahmadabad
496Entering 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
3. Designation
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..
Regards,
Amit Seth.
From India, Ahmadabad
Hi Amit, Thx for your immediate response. But I have another doubt, monthlast we have to calculate the EL, SL if not LOP, Pls give me the required formulas or format . Sunitha.R
From Hong Kong
From Hong Kong
Hi Sunitha, Welcome.. find enclosed one of the Leave register, hope it shall help you to keep the track of Leave records.. Regards, Amit Seth.
From India, Ahmadabad
From India, Ahmadabad
Hi Sunitha, Try this format for the attendance, It is partially automated, you can enhance as per your requirement. Abraham
From India, Hyderabad
From India, Hyderabad
Dear Sunitha
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.
Regards
L.Kumar
From India, Madras
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.
Regards
L.Kumar
From India, Madras
Hi Abraham,
The format which you forwarded is suits to my company.
But still I have small doubts in formulas. If it is possible can you give me your ID OR CONTACT NO. My mail ID is
Once again thanks to all.
Sunitha.R
From Hong Kong
The format which you forwarded is suits to my company.
But still I have small doubts in formulas. If it is possible can you give me your ID OR CONTACT NO. My mail ID is
Once again thanks to all.
Sunitha.R
From Hong Kong
Hi Kumar, Thanks for your suggestion. I am maintaining the Muser Roll at the same time I have to maintain Excel Sheet also. Where I have to forward for Corporate office. Sunitha.R
From Hong Kong
From Hong Kong
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.
Nov'08 Attendance Report Format.xls