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
From Pakistan, Karachi
From Pakistan, Karachi
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.
From Pakistan
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.
From Pakistan
Hello Tahira
Thanks for your reply .. please email me the both sheets. at
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
From Pakistan, Karachi
Thanks for your reply .. please email me the both sheets. at
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
From Pakistan, Karachi
[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
From India, Haldwani
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
From India, Haldwani
Dear Tahira, Could you please let me know that what is the main key for a HR guy to learn it? Regards Hejran
From Afghanistan
From Afghanistan
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
From Afghanistan
From Afghanistan
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
From India, Mumbai
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
From India, Mumbai
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.