PDA

View Full Version : Solved: Calculating wage using time format & currency format?



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

xld
02-19-2007, 02:43 PM
=IF(A1="","",A1*24*B1)

Simon Lloyd
02-19-2007, 02:54 PM
Thanks Bob, i did try *24 but at the end of the formula, but everything pointed to having to use something more like 25.589 to get close!

You should see some of the wierd and wonderful calculations i was doing in the formula to achieve what i wanted!

Regards,
Simon