- deluxwashAsked 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?
- JotForm SupportRodjitAnswered 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:
The A6 is just a sample cell, replace it with the cell containing the date and time cell.
Thanks and hope this helps.
- LHEDJAnswered on June 30, 2016 at 11:03 PM
Correction - =text(A6,"hh:mm am/pm")