excel formula to Alteryx

Question

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

Parking Fees.xlsx

Luke_C · Accepted Answer

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.