Simon Lloyd

02-19-2007, 02:33 PM

Hi all i have a column which shows time worked in this format 00:00:00 and a column which has values in currency format ? i.e ?6.00, what i need is a formula to work out what the wage would be in the next coulmn i.e

Column A Column B Column C

00:30:00 ?7.00 ?3.50

My current formula is =IF(A1="","",A1*B1) however i have to format C1 as time in order to see the result almost correct the above would show 3:30, i have tried varying multiplications and divisions but cannot get it exact in currency format.

Any ideas?

Regards,

Simon

Column A Column B Column C

00:30:00 ?7.00 ?3.50

My current formula is =IF(A1="","",A1*B1) however i have to format C1 as time in order to see the result almost correct the above would show 3:30, i have tried varying multiplications and divisions but cannot get it exact in currency format.

Any ideas?

Regards,

Simon