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
Acknowledge(0)
Amend(0)
7From Pakistan, Karachi
Acknowledge(0)Amend(0)
Hello Umer,
I have created an attendance sheet with time in and out. I hope this will work for you. It calculates the total working hours worked in a month. You just have to total the sum hours of in/out, and it will calculate the total automatically as I have applied a formula. I manage another sheet only for absences and half days. If you want that, I will provide it to you.
Thank you.
From Pakistan
Acknowledge(0)Amend(0)
I have created an attendance sheet with time in and out. I hope this will work for you. It calculates the total working hours worked in a month. You just have to total the sum hours of in/out, and it will calculate the total automatically as I have applied a formula. I manage another sheet only for absences and half days. If you want that, I will provide it to you.
Thank you.
From Pakistan
Acknowledge(0)Amend(0)
Hello Tahira,
Thanks for your reply. Please email me both sheets at
. I hope it will meet my requirement. My requirement is to be able to count the number of hours a person has worked. Then, if they are coming late, I will get the number of lates and late hours.
Thanks for your help.
Regards,
Umer
From Pakistan, Karachi
Acknowledge(0)Amend(0)
Thanks for your reply. Please email me both sheets at
Thanks for your help.
Regards,
Umer
From Pakistan, Karachi
Acknowledge(0)Amend(0)
Dear All, Please have a look on attach file this will hepl you....
From India, Ahmadabad
Acknowledge(0)Amend(0)
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hi, See this will work out ur requirement. Regards, Sritha
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
[QUOTE=Umarsh;1288682]
Dear All,
If you can help me out, I am looking for the attendance sheet with time in/out of each employee. In the summary sheet, I need totals for lates, total late hours, leaves, and half days.
Regards,
Krishan Chandra
From India, Haldwani
Acknowledge(0)Amend(0)
Dear All,
If you can help me out, I am looking for the attendance sheet with time in/out of each employee. In the summary sheet, I need totals for lates, total late hours, leaves, and half days.
Regards,
Krishan Chandra
From India, Haldwani
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From Afghanistan
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From Afghanistan
Acknowledge(0)Amend(0)
Dear Tahira,
My name is Siddharth, and I work as an Executive in Admin/HR. Could you please share an Excel sheet formula with me for calculating the In-Out time of Staff and Workers based on an 8-hour workday? Additionally, I would like to know how to calculate the overtime hours for each day if they work beyond 8 hours.
Thank you and regards,
Siddharth Paigankar
From India, Mumbai
Acknowledge(0)Amend(0)
My name is Siddharth, and I work as an Executive in Admin/HR. Could you please share an Excel sheet formula with me for calculating the In-Out time of Staff and Workers based on an 8-hour workday? Additionally, I would like to know how to calculate the overtime hours for each day if they work beyond 8 hours.
Thank you and regards,
Siddharth Paigankar
From India, Mumbai
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.