Calculate Minutes Late (also if with Grace Period)

This video shows how to calculate minutes late wherein you have the start time and you have the supposed or target or shift start time. This video considers hours late. Later in the video, the formula will be enhanced to consider grace period for being late.

[@adrianraygonzales4149]

Such a helpful video, thanks!!!

[@MotlatsoMogale]

Very Informative video👌 How do we calculate Departmental average number of hours per employee per month

[@ExcelInsights]

You need to have a column with Department Names. Then, after following this video, use SUMIFS

[@SpyroCSagum]

This is very helpful..Thank you

[@ChristianLayola]

This is very helpful. How about the computation of 1 hr lunch break from 12nn to 1pm and, the 1hr breaktime will not deduct for the employee reported for half day and undertime work hours? Thank you

[@ExcelInsights]

Hi, Christian, this solution in the video is only to deduct lates. If you need to deduct lunch time, you can less 60 minutes from the result.
It is best to have another column do this because: what if the employee arrived 11AM? Will the person take lunch time still? Consider that as well

[@Yomi.Ladipo]

What If the time in is blank? which means that people didn't come, how do I go about that formula

[@fahadq812345]

Hello, how can I calculate the accurate deduction based on the figures we calculated as we learned in video?
Thanks 🙏🏻

[@ExcelInsights]

If your company deducts for every minute late, calculate the per minute salary of the person then multiply to the minutes late.
Per minute salary is Daily Salary Rate / Number of Working Hours per Day / 60.

[@fahadq812345]

Thanks 🙏🏻🙏🏻🙏🏻

[@nelsonjrbelleza9866]

salamat po..

[@lws4790]

is the computation applicable on older versions? 2013 kasi gamit ko eh

[@ExcelInsights]

Do you mean the formula?
Yes, the formula will work in 2013.
Why don't you try it out to check.

[@DarkGaming-wb4et]

how to calculate po info po sa attendance percentage if may absent/tardy po

[@ExcelInsights]

Hi, you check with your policy.
But generally, this is a simple math problem you are asking.
If I came to work 9 out of 10 days-- how do you calculate the percentage then?

[@rochelleannasuncion8075]

Undertime and OT naman po

[@aldrinalejandro2732]

Value skin nalabas

[@ExcelInsights]

VALUE means the data you are using is not the correct data type. Maybe it is being read as text when what you need is a number (for date/time)

[@AldrinAlejandro-b2y]

Thank u and Godbless​@@ExcelInsights

[@edison8214]

salamat po

[@ExcelInsights]

You're welcome