How can I collect the time (date, star and end time ) of each entry?

Export the form responses to Excel; each response row includes separate Start time and Completion time values that can be used to derive the response date, start time, end time, and completion duration.

Export the timestamps

1. Open the form in Microsoft Forms.
2. Select View responses (or the Responses tab).
3. Select Open results in Excel.
   • Open results in Excel creates a workbook with a live connection to the form.
   • Download a copy creates an offline snapshot that will not receive later responses.
4. Open the workbook and locate the Start time and Completion time columns. Microsoft documents these among the first five columns of the exported response data, with one response per row.^1^

The timestamps apply to responses already submitted, so no additional date/time questions need to be added to the questionnaire.

Prepare the data in Excel

Assuming the exported data has been converted to an Excel table and its timestamp columns are named Start time and Completion time, add these calculated columns:

Response date

=INT([@[Start time]])

Format the result as a date, such as dd/mm/yyyy.

Start time only

=MOD([@[Start time]],1)

Format it as hh:mm:ss.

End time only

=MOD([@[Completion time]],1)

Format it as hh:mm:ss.

Time taken to complete the form

=[@[Completion time]]-[@[Start time]]

Format the duration using the custom number format:

[h]:mm:ss

If the export is not an Excel table, use ordinary cell references instead. For example, if Start time is in B2 and Completion time is in C2:

=INT(B2)
=MOD(B2,1)
=MOD(C2,1)
=C2-B2

Count responses by exhibition date

1. Select any cell in the response data.
2. Choose Insert → PivotTable.
3. Add Response date to Rows.
4. Add Respondent ID to Values and set it to Count.
5. Sort the count from largest to smallest.

This shows which date received the most submissions. If finer analysis is needed, add an hour column:

=HOUR([@[Start time]])

Then use Response date and the hour in the PivotTable to identify the busiest response periods.

The Start and Completion times measure when the visitor began and submitted the questionnaire. They do not necessarily represent when that visitor entered and left the exhibition. If actual arrival and departure times are required, those must be collected separately in the form or through a check-in/check-out process.

References

1. Check and share your form results | Microsoft Support