Anyone good with poivot tables/formatting?

[mattyfez]

Hey all,

I'm trying to build a pivot to look at the length of phone calls, and to filter out any calls that are for example, under 1 min 20 secs long..

The data table displays call length in HH:MM:SS format but I get a massive list of decimals as per below, which looks like its formatted as 'general' rather than 'time' the list is also massive..

Does anyone know how to do this?

Thanks

 

[dim_pwn]

What's the format in the data the pivot points to?

 

[mattyfez]

What's the format in the data the pivot points to?

'call duration1' is the data column the pivot pulls from, and in the original spread sheet it's in hours, mins and secs for example: 00:04:35 , but now I've got all this decimal stuff on the pivot.. I'm sure it's a format issue.. but I cant really see how to fix it

 

[hood1971]

Click on the CallDuration1 in column labels, select field settings and then number format at bottom. Change it to date setting matching your request or else select custom and enter

hh:mm:ss

Also you could format original values.