durwoodghib
New Member
- Joined
- Apr 5, 2018
- Messages
- 4
Good Day,
My oldest daughter is in her first year running cross country. I have enter info in an excel file to track her times based off date (mm/dd/yyyy), location (Text), and time (mm:ss.0). She runs some locations multiple times in a year and will go back to some locations over the next 6 years.
What I am trying to do is create a pivot table that can ultimately show a trend line over time of her improvements. But first I am just trying to create a pivot table to organize things. However, when I have tried to put times in the value section I get "1's" instead of the time values.
I have put the file in a google drive that you can view if you would like to try and see what I was attempting.
https://drive.google.com/open?id=10-9sAwklcdbnhO-JqKWUj4s_WD0n4e2-
If it doesn't work let me know.
Thanks in advance for help on this,
Durwood
My oldest daughter is in her first year running cross country. I have enter info in an excel file to track her times based off date (mm/dd/yyyy), location (Text), and time (mm:ss.0). She runs some locations multiple times in a year and will go back to some locations over the next 6 years.
What I am trying to do is create a pivot table that can ultimately show a trend line over time of her improvements. But first I am just trying to create a pivot table to organize things. However, when I have tried to put times in the value section I get "1's" instead of the time values.
I have put the file in a google drive that you can view if you would like to try and see what I was attempting.
https://drive.google.com/open?id=10-9sAwklcdbnhO-JqKWUj4s_WD0n4e2-
If it doesn't work let me know.
Thanks in advance for help on this,
Durwood