Understanding Start and Completion Times in Microsoft Forms
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.

- 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.
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.
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.
Navigate to forms.office.com and click on the specific quiz or survey you want to review.
Click on the 'Responses' tab located at the top of the form editing page to view the summary of all submissions.
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.
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 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. Download the Forms Data: Click 'Open in Excel' in your Microsoft Forms response page to save the .xlsx file to your device.
- 2. Open with WPS Spreadsheet: Launch WPS Office, click on 'Open', and select the downloaded response file to view the timestamp columns.
- 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.

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.




