ChloeSpurge
New Member
- Joined
- May 5, 2021
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
HI,
I have some total duration times by sites and week number (over 24 hours) in this table (below). I've converted the Sum of weekly Hours (originally a decimal) into a duration, then created a customer column with the correct time format.
Now I need a way to sum these hours from the data into a table like this (below) on my dashboard but in time format rather than decimal (as below). Then I'd want to use slicers to filter total hours by specific sites. Is this possible?
Thanks in advance for any help
Chloe
I have some total duration times by sites and week number (over 24 hours) in this table (below). I've converted the Sum of weekly Hours (originally a decimal) into a duration, then created a customer column with the correct time format.
Now I need a way to sum these hours from the data into a table like this (below) on my dashboard but in time format rather than decimal (as below). Then I'd want to use slicers to filter total hours by specific sites. Is this possible?
Thanks in advance for any help
Chloe