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