Excel submissions date & time problem

  • Profile Image
    corporatevents
    Asked on April 04, 2016 at 10:45 AM

    Hi we have launch a quiz toaday at 11:00 am and this quiz should ended at 24:00pm in Belgium, now at 15:26 pm whe have downloaded the excel files with the submissions it seems to have a problem with the timestamp used in the field Submission date, the first submissions begins at 

    2016-04-04 04:52:41

     wich is impossible we start the quiz at 11:00 am

    We are afraid that the quiz won't finish at 24:00pm or that people are going to discuss because of that problem.

    Can you help us ?

    Thanks in advance

    Gérard 

  • Profile Image
    Charlie
    Answered on April 04, 2016 at 12:53 PM

    The submission date and time depends on the timezone of your account settings. I'm checking your account and the timezone is set in EST. 

     

    You need to set the timezone in Belgium to sync with your own time.

    You could also integrate your form to Google Spreadsheet to give you a real-time list of submissions online.

    Let us know if that helps.