Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Convert Time HH:MM:SS to seconds

Highlighted
7 - Meteor

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Genty 

 

Would this do the work?

 

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

 

Cheers,

Highlighted
7 - Meteor

Yep works for me, thank you.

Labels