SOLVED
How to convert String into Time Format ( 75 into 01:15:00) ? Help
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
AbhirupMukherjee09
7 - Meteor
‎10-31-2022
06:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Input data :
10
20
40
60
75
I want the output as :-
00:10:00
00:20:00
00:40:00
01:00:00
01:15:00
I have tried the DateTime Tool and the DateTimeParse () but 60 and 75 is giving Null.
Expression used - DateTimeParse([Field],"%M").
How can I get the correct output format ?
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
- Tips and Tricks
- Transformation
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎10-31-2022
09:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Look at this topic (duplicated):
How to convert String values to Time format ? (75 ... - Alteryx Community
joelmiller66
9 - Comet
‎10-31-2022
10:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is a solution below. It's using a formula to calculate the hours and mins. They create the string that you need.
Workflow is attached below.
