Attendance Sheet With Time In/out - Xls Download

Dear All
If u can help me out i am looking for the attendance sheet with time in / out of each employee & in the summary sheet i need total lates , total late hours ,leaves & half days.
Regards
Umer

Hello Umer
I have made a Attendance sheet with time in n out. i hope this ll work for you. it calculates total working hours worked in a month, you just have to total the sum hours of In/Out and it ll calculate total automatically, i have applied a formula. i manage another sheet only for absence and half days, if you want that i ll provide it to you.

Hello Tahira
Thanks for your reply .. please email me the both sheets. at
[Login to view]
i hope it will meet my requirement. well my requirement is that i can count the number of hours a person has worked. Then if he coming late i will get the no of lates & late hours.
Thanks for your help
Regards
Umer

Dear All,
Please have a look on attach file
this will hepl you....

Hi,
See this will work out ur requirement.
Regards,
Sritha

[QUOTE=Umarsh;1288682]Dear All
If u can help me out i am looking for the attendance sheet with time in / out of each employee & in the summary sheet i need total lates , total late hours ,leaves & half days.
Regards
krishan chandra

Dear Tahira,
Could you please let me know that what is the main key for a HR guy to learn it?
Regards
Hejran

Hello Tahira,
This is Mahfooz Hejran HR Manager at USAID projects, if you need anyth HR related, I am all available all the time.
Regards
MH

Dear Tahira
Myself Siddharth working as a Executive - Admin/HR, Pl share me Excel sheet formula for Staff & Workers In-Out Time calculation for 8 hrs base. After 8 hrs how to calculate OT hours everyday if any.
THanks & Regards
Siddharth Paigankar

Dear All, Kindly confirm if there is any new circular on office timings should of General Shift. Also what should be done if a organization is not adhering to the required office. i.e. asking the employees to work beyond 9 hrs