Hi,
The attandance format is not really good coz for every month we have to create new exl sheet n in year end how we will come to knw abt leave availed by employees cl,pl,ml etc. n wht is dis planned n unplanned leaves it's not a perfect phrase u should use cl,pl,ml,ab,hd.how to Carry forward earned leaves?:confused:
Thanks
Regards
Preeti

From India, New Delhi
Herewith I attached other tracking sheet... Revert back with your suggestion
Attached Files (Download Requires Membership)
File Type: xls Attendance Sheet 2008.xls (55.0 KB, 1391 views)

I liked the sheet. It can be very useful. I feel there could be some additions.
1. You are calculating absenteesim. Can't we calculate the days he was present and get it displayed and percentage calculated weekly and monthly.
I have such a requirement. Could you help me with that. My email is
thanks rajeev

From India, Delhi
Dear sir, pls send to me the attendance sheet formet in excel thanking you, regards pawan kumar chauhan
From India, Gurgaon
Attached Files (Download Requires Membership)
File Type: xls ATTAN SHEET.xls (44.0 KB, 599 views)

HI Gurpreet, Indeed a good attendance tracker. However in Formula =SUM(E46:I46)/205 205 stands for what. Regards
From India, Delhi
& why there are 2 values i.e. (1, 0.5) against following fields Planned, Unplanned, Uninformed, Came but left Request you to resolve this query ASAP. Regards
From India, Delhi
hey...that’s such a wonerful piece of inromation, i had been looking fo rsomehting like this to keep a track of my 1000 workforce on the field....:) Thanks once again, Sunita Saxena
From United Arab Emirates, Dubai
hi, i suggest that for easier access to leaves availment tracking of each employees, ask your it personnel to make a database, just provide the details that is going to be included in the said database. that is what we are having now. easy to track each employees, how many remaining leaves.
From Philippines
four our attendance, we are using biometrics this time since am doing the attendance and late tracking monthly.
From Philippines
i want to calculate attendance in excel sheet, with fromulated please can i get it ? pls help / send me
From India, Bangalore
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.