Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this?
if( (ArrivedTime - AptTime) <= 10/24/60 and (AptTime - ArrivedTime ) <= 10/24/60, 'Withing range')
May be like this?
if( (ArrivedTime - AptTime) <= 10/24/60 and (AptTime - ArrivedTime ) <= 10/24/60, 'Withing range')