I have a column "SignIn" that shows the date/time of a staff sign-in. I have another column "Late Flag" that will show if they are late or not. There are sometimes multiple sign-ins/outs throughout the day, So I need the formula to only flag them as late between a certain time frame (09:35:00 AM to 10:15:00 AM).
I have tried a few different formulas - but they keep producing unexpected results (like they all show as late, when they're not).
=IF(AND([SignIn]>"9:35:00 AM",[SignIn]<"10:15:00 AM"]),"Late","")
The SignIn column is a date/time column, the late flag is a single line of text.
(I have tried this without the JSON highlighting the columns)
Any help would be greatly appreciated.