Forum Discussion
Help with timesheet created by MS Forms
Hi Folks, new to this forum so please be gentle 🙂 I have 8 employees who use a mS Form I have created to input their weekly timesheet. At the end of the week, I save the results to an excel file...
You can use Excel's Subtotal feature.
Click anywhere in the data.
Activate the Data tab of the ribbon and click Subtotal in the Outline group:
The Subtotal should propose to add a subtotal for each change in the NAME column, and add it to the HOURS column:
Click OK. Result (with some random dummy data):
Many thanks HansVogelaar. That has worked perfectly. I had a few issues as the SubTotal option was grayed out, but found a solution on the web. Thanks again for your help.
Select the HOURS column.
On the Data tab of the ribbon, click Text to Columns, then click Finish without changing any settings.
Does that make Subtotal available?
- That's it working perfectly Hans. Many thanks.
