Microsoft Forms: Fixing Time Discrepancies Wrong Microsoft Forms Submission Timestamps

By Grace

Are you facing an issue where the submission time in Microsoft Forms isn't accurately reflecting the actual time your responses were sent? You're not alone. This peculiar problem has been reported by many users, and in this guide, we'll delve into why this might be happening and provide you with some tried-and-tested solutions.

Premade templates for Microsoft Forms
Premade templates for Microsoft Forms

Before we dive in, let's quickly understand why the submission time might be crucial for you. Accurate timestamps can help track response rates, identify patterns in engagement, and even ensure that raffle draw timing is fair and transparent. So, let's get started.

Capture data in Microsoft Forms to create a new template agreement in SharePoint
Capture data in Microsoft Forms to create a new template agreement in SharePoint

Why is the submission time wrong in Microsoft Forms?

There could be several reasons why the submission time in Microsoft Forms is incorrect. Let's explore a few possibilities:

Tips for using Microsoft Forms
Tips for using Microsoft Forms

1. **Default Time Zone:** Microsoft Forms uses the default time zone set in your account's region and language settings. If this isn't set correctly, it might cause the submission time to appear incorrectly.

Time Zone Mismatch

Time Off Request Forms - Word Excel Fomats
Time Off Request Forms - Word Excel Fomats

First, double-check your account's default time zone. Here's how:

  1. Click on your profile picture at the top right of the page.
  2. Select View account.
  3. Under Language, ensure the Region is set correctly.

Incorrect Time in Windows

an image of a claim form that is being used to fill out forms for employees
an image of a claim form that is being used to fill out forms for employees

If the time zone in your Microsoft Forms account is correct, check if your Windows system's time is accurate:

  • Right-click the clock in your taskbar and select Adjust date/time.
  • Make sure the date and time are set correctly and the checkbox for Set time automatically is ticked.

Additional factors affecting submission time

Microsoft Flow - Form, into excel, create word document from template, send email, ad
Microsoft Flow - Form, into excel, create word document from template, send email, ad

Besides time zones, there are other factors that could contribute to the incorrect submission time issue:

1. **Server Time:** Sometimes, there might be a slight discrepancy between the time on your device and the server time when the response is recorded.

the microsoft forms logo is shown next to an image of a folder and a file
the microsoft forms logo is shown next to an image of a folder and a file
Top 10 Advanced Features of MS Forms
Top 10 Advanced Features of MS Forms
The Calculator Meme, Psat Memes, Using Calculator Meme, Funny Calculator History Meme, Funny Things On Calculator, Funny Calculator Meme, Calculator Meme Humor, Calculator Memes, Funny Calculator
The Calculator Meme, Psat Memes, Using Calculator Meme, Funny Calculator History Meme, Funny Things On Calculator, Funny Calculator Meme, Calculator Meme Humor, Calculator Memes, Funny Calculator
How to Use Microsoft Forms to Create Professional Surveys
How to Use Microsoft Forms to Create Professional Surveys
Surveys in Excel, hosted on the web
Surveys in Excel, hosted on the web
screenshot of the microsoft word document viewer in windows 7 and 8, with text added
screenshot of the microsoft word document viewer in windows 7 and 8, with text added
Quick tips in Microsoft Forms for Education
Quick tips in Microsoft Forms for Education
Microsoft Forms FAQ
Microsoft Forms FAQ
Award-Winning Fixes for Microsoft Something Went Wrong 1200
Award-Winning Fixes for Microsoft Something Went Wrong 1200

Internet Lag

This could be due to internet lag, which might cause a delay in the submission time being recorded accurately. While there's not much you can do to fix this on your end, Microsoft continually works to minimize such lags.

Outdated interviewer app

An outdated interviewer app on the respondent's side could also cause submission time discrepancies.

2. **Form Settings:** Certain form settings might cause the submission time to be recorded as the time the form was first opened rather than when it was submitted.

Form Settings Review

To ensure this isn't the case, make sure your form settings are correct:

  1. Go to your form and click on the inline settings (the three dots) at the top right of the page.
  2. Under More settings, ensure the Create submission timestamp option is turned on.

Remember, even after implementing these solutions, there might still be a slight discrepancy due to the factors mentioned above. However, these steps should significantly improve the accuracy of the submission time in your Microsoft Forms.

In summary, ensuring accurate submission times in Microsoft Forms involves a mix of checking your account settings, system time, form settings, and being aware of inherent factors like internet lag and server time. Happy form creation!