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

[dkma]

Hello all,

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

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

[AngelosPachis]

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

[dkma]

@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]

@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