What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    I integrated google spreadsheets and I don't want the submission time to be military time. How do I fix that?

    Asked by deluxwash on September 28, 2012 at 11:22 AM

    I integrated my jotform to google spreadsheets and I don't want the submission date to be in military time... i want it to be in standard 3pm vs 15:00. So where do I make that conversion?

  • Profile Image
    JotForm Support

    Answered by Rodjit on September 28, 2012 at 11:33 AM


    I'm sorry but that it how it works at the moment. However you ca always convert the 24 hour (military format) manually into 12 hours format using the following formula on Google Docs spreadsheet:

    =text(A6,"hh:mm a")

    The A6 is just a sample cell, replace it with the cell containing the date and time cell.

    Thanks and hope this helps.

  • Profile Image

    Answered by LHEDJ on June 30, 2016 at 11:03 PM

    Correction - =text(A6,"hh:mm am/pm")