Multiplying hours format by number format ?

[Pauljj]

I have a spreadsheet with peoples hours worked, formatted as [h]:mm:ss

Their rate of pay, formatted as 0.0

In order to multiply them together, with the result formatted as 0.0, I an getting random results, does anyone know where I am going wrong ?

Thanks
Paul

 

[AlanY]

even the cell is formatted as time, excel still treat is as fraction of a day, if you convert it back to hours by x24 should give you the right answer

 

[Pauljj]

Thank you Alan

 

[AlanY]

you're welcome