Employee Tardiness Clock Time >5 Mins

Good evening one and all,

This is my first post though I have been using this site as a resource now for some time. I am working on a tricky formula to show employees arriving later than 5 minutes to their scheduled time. Currently the formula shows as: =IF(AA50="","",IF(Q50>0,"ONTIME",IF($AA50>0,"LATE",IF($AA50<0,"EARLY",IF($AA50=0,"ONTIME"))))) I believe I should change $AA50>0,"LATE" to $AA50>0.92,"LATE" but keep getting a FALSE error. Am I overcomplicating things? Any help would be greatly appreciated!! E

Hi edwyer247,

Welcome to the forum.

I guess Q50 is a type in your formula.
If AA50 is the difference of actual arrived time - scheduled time, use below formula:-

=IF(AA50="","",IF(AA50=0,"ONTIME",IF($AA50>0,"LATE","EARLY")))



Regards,
DILIPandey

<click on below 'star' if this helps>