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):
i am trying to create an MS forms timesheet template for my employees with the ability to export to excel however I’m struggling to even get the form off the ground, is there any chance you have a template you have created that you could share? It would be really appreciated!
Thanks
Matty
- Hi Matty,
I am not sure how to save the form as a template to enable you to view it. However, I can offer the following:
1. I have created a form that my employees can access. (if you create a form for those with an MS account, then their name and date are collected automatically so no need for those entries in the form).
2. Our form asks 5 simple question. What day of the week is it (using a drop down list), Who are you working for, Where are you working, what were you doing and finally How many hours did it take you. Our user can enter as many entries in a week as required. Some will work all day on the same job, some may work a few hours on one job and a few hours on another, etc.
3. At the end of the week, or when ever it suits you, we then download an excel sheet of all the answers. If everyone has filled it in correctly, we can then delete all the responses to clear for the following week.
4. Now comes the tricky part. Each entry will be in a random order, so we use a macro to sort the entries into days of the week, then each individual. We then insert a line and add each individual hours. We also delete all the columns we don't require and resize the columns so that it prints on a single sheet of paper in landscape mode. The macro then asks for the week no and it is printed in the header. We then end up with a PDF of our employees timesheets for that week which can be filed or printed as required.
The best way to do the macro is record it as you sort the sheet out, then you can go back in and edit it as needed later.
I hope this helps.
