SOLVED
Convert Time HH:MM:SS to seconds
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Genty
7 - Meteor
‎11-29-2019
05:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
17 - Castor
‎11-29-2019
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Genty
Would this do the work?
DateTimeHour([Field1]) * 3600 + DateTimeMinutes([Field1]) * 60 + DateTimeSeconds([Field1])
Cheers,
‎11-29-2019
05:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yep works for me, thank you.
