Idenitfy the closest time-2

[Ronal_bal]

Following up request with https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Indentify-the-closest-time/m-p...

Please help me with following,

i.e. The closest time should be within 30 Minute range (+30 and -30 minutes)

The value for column C when A=1 should be closer to +30 or -30 minutes.

If the Value when A=1, the timings within 30 min(+) or 30 Min(-) then flag okay

if the value when A=1, for the timing which are greater than 30 minute(+) and not less then 30 min (-) intreval then delayed

if the value A=1, for the timing which are greater than 30 minute (-) and not less then then 30 min (+) intreval then ahead.

@Qiu @caltang 

There can be 3 or more timings which can be within the 30 minute(+,-) range. 

[caltang · Accepted solution]

Checked your logic, kindly confirm below:

Basically, your flag for "Ahead" is if the Value of A = 1, and the time recorded is earlier than the time recorded for when A = 1, then that's Ahead of Schedule - correct?

Hope this helps @Ronal_bal 

[Ronal_bal]

Yes, that is correct! Thank you for the help

[Ronal_bal]

@caltang ,

Sorry, I attached the wrong file.

Please refer the folowing file I provided. 

[caltang]

Done - please check: