MS Forms Start/Completion Times

Question

Hello,

All the entries made in Forms are an hour ahead when it populates it's spreadsheet in OneDrive.  The time zone under my regional settings in OneDrive is set for PST, matching the one I'm in.  Any idea on how to correct it when it populates?

Answer 1

Hello Jess_11,

My name is Juan Pedro, I am an Independent Advisor and consumer of Microsoft products. I will be more than happy to assist you today!

The spreadsheets of Form results may be the UTC time zone. When users fill in a form, it uses UTC time for recording. So when we open the results in Excel, it shows a time different from our local time zone. In addition, we cannot change this setting.

As a workaround, you may enable editing the exported Excel file, and then add two columns for displaying local time. Use the formula =B3+TIME(4,0,0) and =C3+TIME(4,0,0) to change StartDate/SubmitDate to your local time.

Note: You may modify the formula to display the correct local time.

We understand it is more convenient if the exported Excel file can display the correct local time zone. Microsoft Forms is a new service which has a lot of room to improve. We suggest you submit your feedback via clicking More Options(…) in the upper right corner of Microsoft Forms>Feedback. Your good suggestions will help Microsoft perfect their products and services.

I hope this helped. I will be around in case you need something else.

Thank you.

Answer 2

Thanks!  It's a good workaround.