Forum Discussion
BillZab
Feb 19, 2023Copper Contributor
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...
- Feb 20, 2023
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):
BillZab
Copper Contributor
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.
HansVogelaar
Feb 20, 2023MVP
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?
- BillZabFeb 20, 2023Copper ContributorThat's it working perfectly Hans. Many thanks.