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

E

Enrique

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

Adding Hours & Minutes 3
Time format 2
How do I convert hours, minutes, and seconds into decimal format? 2
how do I calculate a week days hours with the 24hour clock 5
How do I round time down to the nearest half hour? 3
how can I multiply number of hours and minutes by hourly rate? 5
SUM'ing hours for certain workers 2
How to Sum Time in Hours & Minutes 9

Top