Equivalent formula in alteryx for #duration(1,0,0,0)

Question

Hello all,

I'm just figuring out the equivalent for the Excel Power query formulae for  Duration

eg #duration(1,0,0,0)

AngelosPachis · Answer

@dkma difficult to tell without a look at the data, but that sounds like an if statement.

So

Create column named [Duration of worked hours]

If [Employee work hours field]<6 then 6
ELSE [Employee work hours field]
ENDIF

dkma · Answer

@AngelosPachis

Actually, In a formulae condition if the any employee works less than 6 hours of time, we should add default 6 hours of duration to the worked hours

that's what the condition is

AngelosPachis · Answer

Hi @dkma ,

If I understand the duration formula correctly, it estimates the duration between two dates in days right?

The equivalent in Alteryx would be :

DatetimeDiff([StartDate],[EndDate],"days")

Hope that helps,

Angelos