I’ve attached November’08 Attendance Report Format for you guys. This format will help you to track the Attendance daily, weekly and monthly. The best part is, in this format you can find first week report in the Sheet-1 and second week report in the Sheet-2 and so on… and on the last Sheet you can find the Month End Report automatically updated. All are formula based.. so you don’t have to do any thing…you just have to fill in the week days as given below.
For present = “P”
For absent= “A”
For Leave= “L”
For Off= “Off”.
For Over Time (OT)= “put numeric, for example for one hour put just “1”.
Just update the First Sheet with Employee Name, Employee Id, Designation, and Department… and the rest of the sheet will be update automatically.
Hope this format is helpful for you. Appreciate your feedbacks and comments…
Note: all the HR if possible mail me your details like which company you work for and your contact details @ , so that if possible we’ll share more valuable information’s.
Many thanks…and have a rocking day…
From India, Hyderabad
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.