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

Question

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 Answer

Hi @AbhirupMukherjee09

Look at this topic (duplicated):

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