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

  • Profile Image
    deluxwash
    Asked 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
    Rodjit
    Answered on September 28, 2012 at 11:33 AM

    Hi,

    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
    LHEDJ
    Answered on June 30, 2016 at 11:03 PM

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