Hello,
I have a field coming from an app expressed in minutes and needs to format it into an hh:mm:ss format.
I could not find that option in date/time formatter so I’m trying with a Code by Zapier step.
I want a value such as 60 to become 01:00:00 or let’s say 90 would become 01:30:00, etc...
I have no preference for python or JS, whichever one works will do,
Looking forward to reading your ideas.
Cheers,
Thomas
Best answer by Troy TessaloneBest answer by Troy Tessalone
Hi
Try this JavaScript Code
+11Welcome to the Community,
I’m not 100% sure what code you’d need to use in order to convert the time into hh:mm:ss but it should be possible to select that format using a Formatter (Date / Time > Format) step.
As hh:mm:ss is a custom format you’d want to select the Custom value option and then type in the desired format directly into the To Format field. For example: 
You can find out more about using Formatter to adjust date/time formats here: Modify date and time formats in Zaps
Hope that helps! :)
Hi
How do you suggest I set the formatter date/time action for my particular requirement?
I tried a few options but no luck. The below set up returns “12:00:00” when I want 1:00:00 or 01:00:00
Let me know your thoughts.
Cheers
+14Hi
Try this JavaScript Code
Hello
Thank you for chiming in, your code works beautifully 
Appreciate the help
Cheers
+11Ah I see! Sorry for leading you down the wrong path there,
I’m so glad you’ve since been able to get this sorted. Nice work here,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
