Converting HH:MM:SS into hours.

[greg7468]

Can someone please help me out.

I am importing data in the above format.

5 minutes therefore equals 00:05:00

When I create a pivot chart this does not translate correctly and comes out as 0.003472222

I would like the pivot chart/table to show the results as hours.

I would therefore like the chart/table to show 0.08333.

Is there a formula/format I can put in my original imported data to chage it so.

Thanks as always.

Sorry I have just realised that you can format the pivot chart/table results.

[samprince]

Pivot tbales sometimes use the number code for dates & times.

Just highlight the row/column on the pivot table and custom format to

'HH AM/PM'