Forum Discussion
Dynamic tables
I am trying to analyze time spent in four different activities realized everyday. Please see attachd excel sheet. I'm trying to use "Dynamic tables" in order to get time spent per day in minutes ...
Hi Juan,
To apply proper format right click on any cell in the column, click on Value Field Settings and apply proper format. Elapsed time in minutes will be like
Same for per cent.
Also you may select here aggregation (sum, average, etc.)
To have figures by weeks you need to add one more column with week numbers into your source range, like
=WEEKNUM(B2,2)
and group by it (in additional to year and month).
Dear Sergei, thank you very much for the table and help.
I have taken some time to answer back as this is new for me and I need a lot of time to understand and avance.
I hope if you don't mind that I keep on asking in a few weeks once I have all my questions together.
I wish you a nice week, Juan.