Convert Time HH:MM:SS to seconds

[Genty]

Hi,

I am trying to convert HH:MM:SS to seconds E.G 00:01:00 = 60.

Trying to use a formula which is simple in Excel but struggling in Alteryx.

Can anyone help?

Regards

[Thableaus · Accepted solution]

Hi @Genty 

Would this do the work?

DateTimeHour([Field1]) * 3600 + DateTimeMinutes([Field1]) * 60 + DateTimeSeconds([Field1])

Cheers,

[Genty]

Yep works for me, thank you.