Time difference in an if statement

[josephinetedesc]

Hi I have these timestamps:

Apt Date		Arrival	Apt Time	StartTime
Fri 02/06/2017		08:14	08:15	08:21

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???

thank you

Jo

[tresesco · Accepted solution]

May be like this?

if( (ArrivedTime - AptTime)  <= 10/24/60  and (AptTime - ArrivedTime )  <= 10/24/60, 'Withing range')