Equation to fill in "On time" or "Late"

mccaffhm

Hello,

I am trying to create an equation that will generate on time or late depending what the quoted delivery time is and the real delivery time is. I have been able to get thus far but I want to include a parameter so if it is 5 minutes or less late then it will say on time.

For example if a quoted time is 9:00 and the real delivery time is 9:05 or earlier it will say on time, and if the real delivery time is 9:06 or later it will say late.

Here is the current equation I have which simply generates on time or late with no additional parameters:

=IF(TIME([Scheduled Delivery Time]@row) >= TIME([Actual Delivery Time]@row), "On Time", "Late")

AravindGP

Hi @mccaffhm

You can use this formula

=IF(OR(TIME([Scheduled Delivery Time]@row) >= TIME([Actual Delivery Time]@row), TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row)), "On Time", "Late")

Or Simply

=IF(TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row), "On Time", "Late")

AravindGP

Hi @mccaffhm

You can use this formula

=IF(OR(TIME([Scheduled Delivery Time]@row) >= TIME([Actual Delivery Time]@row), TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row)), "On Time", "Late")

Or Simply

=IF(TIME([Scheduled Delivery Time]@row) + 5 >= TIME([Actual Delivery Time]@row), "On Time", "Late")

mccaffhm

That worked, thanks for the help!