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.

[@SpyroCSagum]

This is very helpful..Thank you

[@nelsonjrbelleza9866]

salamat po..

[@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 🙏🏻🙏🏻🙏🏻

[@edison8214]

salamat po

[@ExcelInsights]

You're welcome

[@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)