In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert Time HH:MM:SS to seconds

Genty
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

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @Genty 

 

Would this do the work?

 

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

 

Cheers,

Genty
7 - Meteor

Yep works for me, thank you.

Labels
Top Solution Authors