How to convert String into Time Format ( 75 into 01:15:00) ? Help

[AbhirupMukherjee09]

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 ?

[Felipe_Ribeir0 · Accepted solution]

Hi @AbhirupMukherjee09 

Look at this topic (duplicated):

How to convert String values to Time format ? (75 ... - Alteryx Community

[joelmiller66]

@AbhirupMukherjee09 

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.