How do I multiply an hourly cost by hours expressed in minutes?

G

Guest

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
 
B

Bob Phillips

=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)
 
B

Bernard Liengme

Or just =B1*A1*24 since multiplication is commutative and the order is not
relevant
 
B

Bob Phillips

No, but I added the brackets so the OP could better understand the logic
behind it

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I multiply number of hours and minutes by hourly rate? 5
How to set up a cost estimate spreadsheet? 2
How do I convert hours, minutes, and seconds into decimal format? 2
how to multiply h:mm value by an hourly $ rate 2
how do I calculate hours spent x an hourly rate? 2
How to convert time expressed as a decimal to actual hours or minu 8
wages - multiply hours and minutes by number of hours worked 6
Working with Time in formulas/calculations 2

Top