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.aView original
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?
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:
Date / Time in Formatter Setup:
Date / Time in Formatter Output:
Kindly give it a try and let me know how it goes?
Thanks for hopping back in here to let us know that solved it,
@polmarza. I’m really pleased to see ken.a was able to help you with that Formatter action! 😁
Happy Zapping! ⚡
Thank you very much! It has worked
Yay! 🎉 Thanks for confirming that worked
@polmarza. I’m so glad that sorted it! 😁
@SamB , it worked for Google Sheets, but when I went to search for the information from zapier, it still read the time in 17:30:00 format:
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
Great! Now it's all worked out :)
@ken.a close the thread and mark your answer as correct ^^