Has anyone created a script to use in Google Forms/Sheets to convert or display the military time to 12-hour instead once the form has been submitted by a user?

  • I'd expect that formatting the cell(s) would be the solution, as the sheet doesn't store time in human-readable format anyway. – ale Aug 31 '17 at 17:48

OP has revisited and not bothered to respond to a request for clarification so I presume is not going to return. The solution may be to to format the cells appropriately, for example, if something like this:

WA109305 first example

with something like this:

WA109305 second example

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.