Calculating Rate of Pay and displaying

[KodeLiMe]

Hello all!

I'm trying to put together a time sheet for my graphic design work and I want a cell to calculate the time multiplied by a dollar rate of pay.

I tried setting up the cell that displays the total time and multiplying that by a dollar rate, but that's returning an accurate amount.

Any help would be appreciated thanks!

Jason

[martindwilson]

but that's returning an accurate amount.

job done then!
but seriously
convert time to hours/fractions of hours first
=(((HOUR(A1))*60) +(MINUTE(A1)))/60
then 10:30 will be 10.5 use that to multiply pay by

or much simpler
since i looked it up
=a1*24
format cell as general where a1 is time in10:30 format returns 10.5