Syncing Microsoft Forms With Excel for the Web If you prefer working online, after creating your form in Microsoft Forms, you can sync the responses to Excel for the web.

Learn how to use the Forms for Excel feature in OneDrive to create online surveys. You can create accurate surveys and quizzes with automatic marking.

Click OK to add the Forms command to your QAT. Creating an Excel Table Before using the form, it is advisable to put your data into an Excel table.

Using three Microsoft Excel functions, you can easily parse time components from a full date value.

Enter the date first, then press "Space" and enter the time using a 24-hour clock. Press "Enter" and the date will appear in the cell.

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value.

Enter test data to verify cells are oriented properly and the formula is working as intended. For example, if the "Clock In" time is 14:00 and "Clock Out" time is 18:30, "Total Hours" should be 4.5.