Others

Understanding Start and Completion Times in Microsoft Forms

Anum MushtaqAnum Mushtaq Nov 4, 2026 868 views

Question details

The user needs to understand how Microsoft Forms calculates start and completion times, specifically why the duration between the two timestamps is sometimes unexpectedly short despite the quiz having many questions.

Understanding Start and Completion Times in Microsoft Forms
Product
Microsoft Forms
Device & OS
not provided
Scenario
Reviewing and grading student quiz submissions to evaluate how much time was spent on the assignment.
Observed behavior
The start and completion times are sometimes recorded as being less than two minutes apart, indicating that the system is logging the start time of the most recent session rather than the initial attempt.
Before you start

Ensure you have access to the Microsoft Forms dashboard and are able to open your quiz results in Excel to properly view and compare the exact timestamp data.

Solution 1Recommended

Analyze Form Results and Understand Timestamp Limitations

Learn how Microsoft Forms processes session data so you can accurately interpret the start and completion times in your survey or quiz results.

Microsoft Forms records the start time based on when the user opened the survey or quiz in their web browser or Microsoft Teams. The completion time is logged exactly when the user clicks the Submit button.

However, a known design limitation occurs if a user closes the quiz and returns to it later. Instead of preserving the original start time, Microsoft Forms resets it to the beginning of their most recent session. This explains why a student answering multiple questions might show a completion duration of only a couple of minutes.

1
Open your Microsoft Forms dashboard

Navigate to forms.office.com and click on the specific quiz or survey you want to review.

2
Navigate to the Responses tab

Click on the 'Responses' tab located at the top of the form editing page to view the summary of all submissions.

3
Export results for detailed viewing

Click the 'Open in Excel' button to download a spreadsheet containing raw data. This file will clearly display the exact 'Start time' and 'Completion time' columns for each respondent.

4
Review the recorded sessions

Identify the exceptionally short durations in your spreadsheet. Note that these entries indicate the respondent completed the form across multiple sessions, and the start time only reflects their final visit before clicking Submit.

Analyze Form Results and Understand Timestamp Limitations
Submit Feedback for Feature Improvements: If you require precise timing that records the very first attempt, this is currently not supported by design. You can request this feature by clicking the feedback icon in Microsoft Forms and submitting your suggestion to the Microsoft Forms UserVoice.
Free Microsoft Office alternative

Analyze Microsoft Forms Data Effectively with WPS Office

While Microsoft Forms is used for collecting quiz data, analyzing the exported timestamps requires a reliable spreadsheet application. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office for opening and analyzing your exported Excel files.

  1. 1. Download the Forms Data: Click 'Open in Excel' in your Microsoft Forms response page to save the .xlsx file to your device.
  2. 2. Open with WPS Spreadsheet: Launch WPS Office, click on 'Open', and select the downloaded response file to view the timestamp columns.
  3. 3. Calculate Time Differences: Insert a new column and use a subtraction formula to easily calculate the exact time difference between the Start and Completion columns.
Fully compatible with Microsoft Excel (.xlsx) formats exported directly from Microsoft Forms.Lightweight and fast, allowing you to quickly open large response datasets without lag.Free to use with a familiar user interface, ensuring a seamless migration from other office suites.Advanced formulas and data sorting tools to help calculate exact completion durations.
microsoft office alternative - wps office

Frequently Asked Questions

Does Microsoft Forms track how long a student spends on each individual question?

No, Microsoft Forms only records the overall start time and completion time for the entire form. It does not provide a breakdown of time spent per question.

Why are the start and completion times in my exported results exactly the same?

This can happen if the form was submitted exceptionally fast, if the user had only one short question to answer, or if an automated script was used to submit the response.

Can I prevent respondents from leaving the quiz and returning later?

Currently, Microsoft Forms does not feature a strictly enforced continuous session lock. If users leave the page and reopen the link later, the form allows them to continue, which resets the tracked start time.

Is it possible to view the original start time if a student took multiple sessions?

No, Microsoft Forms permanently overwrites the initial start time with the start time of the most recent session before submission.