Formatting chart data table

[greg7468]

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)