Excel formula

  • Thread starter Thread starter jean
  • Start date Start date
J

jean

In one cell I have hours mins i.e. 7:30. I would like the
formula for another cell to calculate cost of this amount
of time, for example 7:30 @ £30/hour. How would I express
that as a formula.

I have tried straight forward 7:30*30, doesn't work. Any
suggestions please?

Thank you.
 
Hi Jean
try
A1*24*30
where A1 stores your time.<format the resulting cell as number
HTH
Frank
 
XL stores times as fractional days, so to get hours, you need to
multiply by 24:

A1: 7:30
A2: £30
A3: =A1*24*A2 ==> £225
 
Back
Top