well its not so much the pivot table. I have column of times (1:45, 0:16, 0:02...). Each cell is formatted as time.

i have created a pivot table which will show the averages of the times, however one cell is listing time as 01/01/1900 1:45. I have tried to clear content of cell and to format as time.

how to i get rid of the date?