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

Date/time fields are intended to store a point in time. They don't store elapsed time. Calculate the time as hours. Use the currency data type with two decimal places.