
James Lanceley
Member
Members
Dashboards
Power Query
Power Pivot
Power BI
Dashboards
Power Query
Power Pivot
Power BI

Forum Posts: 10
Member Since:
February 6, 2022
February 6, 2022

Hi, i would appreciate any advice on how to sum time values in a pivot table. These time values represent the duration that a student has spent reading books.
Data table name = "DataTable" on the worksheet labelled "ReadingLog"
- The values range from 00:00:00 through to values in excess of 24 hours and they are formatted HH:MM:SS
Pivot table name = "pivotHours" on the worksheet labelled "Hours"
- When i bring the Time Spent field into the values section, all of them are 00:00:00
I've tried many different time formats but just seem to get any to work.
Thank you in advance.
James

Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 490
Member Since:
January 31, 2022
January 31, 2022


James Lanceley
Member
Members
Dashboards
Power Query
Power Pivot
Power BI
Dashboards
Power Query
Power Pivot
Power BI

Forum Posts: 10
Member Since:
February 6, 2022
February 6, 2022


Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 490
Member Since:
January 31, 2022
January 31, 2022

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Vishal Nevase, John Kobiela, Sue Hammond, Malcolm Sawyer
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793
Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
