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.
5th October 2010 From Pakistan
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
6th October 2010 From Pakistan, Karachi
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.
10th June 2011 From India, Haldwani
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
9th September 2015 From India, Mumbai
18th May 2016 From Singapore, Singapore