James Lanceley
Member
Members
Forum Posts: 17
Member Since:
February 6, 2022
February 6, 2022
Offline
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: 852
Member Since:
January 31, 2022
January 31, 2022
Offline
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 852
Member Since:
January 31, 2022
January 31, 2022
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy, Carol Egan-Davis, Ross Denney
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 289
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Kevin Sanderson
wer klaus
Richard Gower
Sanket Rathod
Tung Vo
Forum Stats:
Groups: 3
Forums: 24
Topics: 6879
Posts: 30150
Member Stats:
Guest Posters: 49
Members: 33697
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —