Format and calculated fields

[Robert C]

I have a calculated field whcih returns the amont of time spent on a project and it is formated to hh:nn:ss. I would like to be able to multiply this by the hourly rate for the project which is in pounds sterling.

At the moment I have =[TimeSum]*[RateChargable] but this does not return the right figure. Any help would be gratefully received. I have searched the forum but with no luck.

Many thanks

Rob