Time difference in an if statement

josephinetedesc — Mon, 05 Jun 2017 04:12:31 GMT

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

Re: Time difference in an if statement

tresB — Mon, 05 Jun 2017 05:00:17 GMT

May be like this?

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