Calculate from time formatted cell

G

Guest

Greetings,
Say if cell A1 is 8:30 hours, (ie 8.5 hours). I want to multiply by an
hourly rate to get a cost. ie if the rate is £10 per hour then the calculated
result in B1 will be £85.00. What formula/formatting do I need in B1 whilst
retaining the time format in A1
Many Thanks
 

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

Calculate elapsed time excluding specific timeframe 10
Time Calculation 5
Simple Time sheet, calculate OT 2
I need calculated time in a "real number" format 2
TIME X MONEY 1
Calculating payroll cost 1
how to multiply h:mm value by an hourly $ rate 2
EXCEL GURU WANTED - Time calculations 4

Top