Data of google spreadsheet will be missing only a portion if you input data from the form.

  • s_mikami
    Asked on May 16, 2014 at 8:09 AM

    Googleスプレッドシートのデータは一部のみが欠けされるフォームからあなたの入力データの場合。 

    協力を解放するために通常の状態に戻り、再び一緒に仕事を。 

    私に失われたデータの原因を教えてください。

    Jotform Thread 378298 Screenshot
  • Welvin Support Team Lead
    Replied on May 16, 2014 at 11:16 AM

    Hi,

    I think the time is automatically converted to 24 hours. As you could see, 17:20, 15:20 and some of it in the spreadsheet.

    I would advise to do the following:

    Click the field column > click "More Formats" > Choose "Time" from the list:

    Data of google spreadsheet will be missing only a portion if you input data from the form Screenshot 20

     

    Doing this should restore the AM/PM time format. If not, please update us here.

    Thanks