Forum Discussion
vins322021
Feb 24, 2021Copper Contributor
weekly status report
Dear All, On a weekly basis I create a weekly status report with all the daily activities completed at work. Every microsoft excel tab corrisponds to a week, ie: CW01, CW02, CE03, etc. Now I am aske...
- Mar 25, 2021
Hi Vin
You can actually use my pivot table but if you want to follow the steps to create your own you need to do the following:
- Select any cell in your pivot table
- This will display the PIVOT TABLE TOOLS at the top right hand of the ribbon
- Select the DESIGN option
- On the far left select the Report Layout drop down and then choose Show in Tabular Format
- Also on far left sect the Subtotals drop down and then choose Do Not Show Subtotals
- The Sum of Effort in Hours columns defaults to decimal; you need to change the format to HH:MM; Place cursor on heading cell, right click mouse and select Value Field Setting; This opens a new window so select Number Format , then choose Custom; you can scroll down the values until you find hh:mm or you can type hh:mm if you can't find it in your list.
I hope you can follow these steps!
regards,
Peter
peteryac60
Feb 24, 2021Iron Contributor
Please provide a sample of your current format and I can look at this for you.
regards,
Peter
vins322021
Feb 24, 2021Copper Contributor
peteryac60
The current format is a simple spreadsheet with different tabs that will corrispond to the week number of the year (CW01, CW02, CW03, etc.). The only formula used is to sum up the total amount of weekly worked hours. Basically, I am asked to avoid 52 tabs (each for every week of the year) and only have a column with a dropdown option that selects the week number... Hope this additional information helps!