I want to put a formula in Excel attendance sheet to calculate late timings of employees if they are late than the official time. For example, my office time starts at 8:00 AM. I want to calculate the late timings of employees if they are reaching 10 minutes late or 1 hour, etc.
Please help to put a formula for this. Many thanks.
From Pakistan, Karachi
Acknowledge(0)
Amend(0)
12Please help to put a formula for this. Many thanks.
From Pakistan, Karachi
Acknowledge(0)Amend(0)
It is very simple. Formula is =start time - real time. Make 3 columns, in first column start time, in 2nd column real time and put the formula in 3rd column is = 1st column-2nd column. Thats it. anju
From Germany, Aachen
Acknowledge(0)Amend(0)
From Germany, Aachen
Acknowledge(0)Amend(0)
Hi Zainab,
Please find the Attendance Formula Sheet which I had created. You can modify it as per your needs. Hope it might be of some use to you.
Please note: Timings need to be entered in a twenty-four-hour format.
Regards,
Mamatha
Acknowledge(0)Amend(0)
Please find the Attendance Formula Sheet which I had created. You can modify it as per your needs. Hope it might be of some use to you.
Please note: Timings need to be entered in a twenty-four-hour format.
Regards,
Mamatha
Acknowledge(0)Amend(0)
I want to create a time attendance sheet that can calculate the late arrival time of employees. For example, if I start work at 8:30 and someone arrives at 8:45, it should display 15 minutes late. Currently, I use the formula = B2 (real time) - 8:30 (start time), but it shows a negative value (-8:30) when my sheet is empty. How can I resolve this issue?
From Thailand, Bangkok
Acknowledge(0)Amend(0)
From Thailand, Bangkok
Acknowledge(0)Amend(0)
We are deducting salary for latecomers. I am working with a pharmaceutical distributor, and here leave facility is also not available. If one day is missed without prior information, we deduct double salary. Is this correct, or is there any other alternative available? Please let me know.
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
Here is the corrected text with proper spelling, grammar, and formatting:
---
CAN ANYONE PLEASE PROVIDE A FORMAT FOR ATTENDANCE THAT CAN CALCULATE 3 DAYS OF BEING LATE AS ONE ABSENCE? I ALSO NEED A FORMULA FOR PAID LEAVE (PL) AND CASUAL LEAVE (CL), WHICH SHOULD BE CONSIDERED AS PRESENT ON MY ID
.
---
From India, Bangalore
Acknowledge(0)Amend(0)
---
CAN ANYONE PLEASE PROVIDE A FORMAT FOR ATTENDANCE THAT CAN CALCULATE 3 DAYS OF BEING LATE AS ONE ABSENCE? I ALSO NEED A FORMULA FOR PAID LEAVE (PL) AND CASUAL LEAVE (CL), WHICH SHOULD BE CONSIDERED AS PRESENT ON MY ID
---
From India, Bangalore
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.
Folklore Time and Attendance.pdf
Employee excel sheet.xls