No Tags Found!


Hi CiteHR. I’m looking for a formula to calculate lateness of employees with different schedules during the week
From Costa Rica, Heredia
Acknowledge(0)
Amend(0)

Clarifying Late Coming Policy

Your requirement is not clear. For late coming, you have to send a circular to all the employees about the timings and the maximum relaxation that the company prefers:

- A maximum of thirty minutes or three times in a month.
- For example, if an employee is delayed by 5 minutes, 10 minutes, and 5 minutes, totaling twenty minutes, then their accepted relaxed time is over. If the delay reaches 30 minutes in a single stretch, they are not eligible for any further relaxation, either one or the other.
- Beyond 3 times or 30 minutes, the penalty needs to be mentioned.

In the above manner, you have to prepare a communication and forward it to all the employees and implement it.

Thanks and regards,
kamsh

From India, Hyderabad
Acknowledge(0)
Amend(0)

I'm having some trouble computing the lateness of employees. The normal hours of work are 8 hours, from 8:00 am to 5:00 pm, with a lunch break from 12:00 pm to 1:00 pm. I can only calculate the number of hours worked, but not for lateness.

Calculating Lateness Without Decimalization

For example, if an employee logs in at 8:30 am, then they are late by 30 minutes. How can I calculate that without the need for decimalization of minutes?

From Philippines, Sampaloc
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.