Hi I have these timestamps:
|Apt Date||Arrival||Apt Time||StartTime|
My formula for Arrival time - Aprt Time
interval(ArrivedTime - AptTime , 'hh:mm')
I have formatted the answer to General:
I want to show if the person arrived before the AptTime to show EARLY or LATE
if(interval(ArrivedTime - AptTime, 'mm') >= 0, 'Early') (Early works but all other values are blank)
Would it be possible to show if the ArrivedTime was within 10 mins either way of the AptTime???