Formatting chart data table

Hi all, bit of a weird one but I have imported data that includes duration time with a format of hh:mm:ss.

I have created a pivot chart which works fine and the axis scale reports correctly. (see attached file)

However I need to add the data table on the screen as well.

When I do so the data table appears but the duration data within the table is in days format. Therefore a 22 minute duration that appears in the data as 00:22:02 appears as 0.0157 in the data table.

Can anyone help as I can't seem to find out how to change the format in the table or how to affect it by changing any other format.

Thank you. (using xl2003)

"Is it possible to post small example file."

I now see you did.

In the pivot table select the Sum of Duration field and set the number format to
[h]:mm

Of course Andy, why didn't I think of that.

Thanks for your help.