The Google Form returns the times in the format "17:30:00" in the Google Sheets answer sheet. So, I need to format this time to "1730" with Zapier.
If it is not possible to do it with "Formatter by Zapier", can it be done with Js (although it is not the desired option)?
How can I do this?
Thanks for your time :)
Best answer by ken.aBest answer by ken.a
Hey
I’m glad the suggestion by SamB worked. That said, looking at the screenshot you sent, the “To Format” field seems picky when converting the time. What you want to do here is to replace the “hh” with “HH” and leave the “From Format” field blank. Here’s what it will look like:
Kindly give it a try and let me know how it goes?
+11Hi
It should be possible to format the column that contains the times directly within Google Sheets.
To do that you’d select the column then go to Format > Number > Custom date and time:
Then select the relevant options to create the custom format:
Which should then display the times in the desired format:
Then they should come through to the Zap in the desired format:
Which would save you needing to use a Formatter (Date / Time > Format) action to convert the time into HHmm format.
Want to give that a go and see if that does the trick?
+11Yay! 🎉 Thanks for confirming that worked
Sorry
Then I tried to do it through Zapier. I think it's configured correctly, but the answer I get is not in 24h format... This is what happens when I click on "test":
But the result is 0530 instead of 1730.
Can you think of a solution?
Thanks a lot Sam
+6Hey
I’m glad the suggestion by SamB worked. That said, looking at the screenshot you sent, the “To Format” field seems picky when converting the time. What you want to do here is to replace the “hh” with “HH” and leave the “From Format” field blank. Here’s what it will look like:
Kindly give it a try and let me know how it goes?
Great! Now it's all worked out :)
Please
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
