excel formula to Alteryx

[Raghadhq]

Hello

I have attached excel file for the formula i use in excel, and i want to convert into Alteryx, would that be possible?

thanks

[Luke_C · Accepted solution]

Hi @Raghadhq 

Here's how:

• Convert date time field to proper alteryx format
• Compute difference using multi-row formula tool.
  • Note: I used datetimediff() in seconds, and converted to hours. Using the hours setting rounds off which is not optimal for the calc.
• Implement your logic using if statements. 

[Raghadhq]

thanks it worked!