How do I multiply an hourly cost by hours expressed in minutes?
=B1*(A1*24)
where B1 is the charge, A1 is the time, format it as General.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Enrique" wrote in message
...
I got a very long worksheet with tasks times in minutes (00:12 for 12
minutes
or 01:36 for 1 hour and 36 minutes), and hourly charge rates. I need to
work
out the cost in £ of those fractions of hours (and sometimes longer than
one
hour as you can see).
I can't get the answer I look for. For example: a time cell has 00:12, and
the hourly rate is 155, I should get to the 31 cost forthe 12 minutes, but
can't.
Any ideas?
Thank you very much
|