BLACK FRIDAY SALE 20% OFF ALL COURSES

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

Forum Posts: 13
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

Trusted Members
Moderators

Forum Posts: 692
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: 13
Member Since:
February 6, 2022
February 6, 2022


Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

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

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Timothy, Alan Sidman, Jill Niemeier, Pam Baillie, Jessica, Lila Huron-Albinger, Todd Heckman
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 227
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Kelvin H
Anya Ledwith
Mark Melvin
Stuart McInnes
Naji Moukhachen
Robert Mason
Debora Cohen
Kris Whitaker
Rajesh Jawajala
Todd Heckman
Forum Stats:
Groups: 3
Forums: 24
Topics: 6641
Posts: 29140
Member Stats:
Guest Posters: 49
Members: 33096
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
