How multiply hours and price?
 

I need help. I have price pro hours (exp. 27,03eur/hour) and time written in
one cell in form h:m:s (exp.28:35:00). How can I make formula to multiply and
show total cost (28:35:00*27,03=?. Thanks

How multiply hours and price?
 

Assuming that the time amount (28:35:00) is stored as an internal date/time
and is only formatted as time and that the per hour amount (27.03 - you may
need to replace the comma (,) with a point (.)) is stored as a number and not
as text then a simple formula =a1*a2 should do it.

Remember to the keep the data simple and use formatting to make it appear as
you want it - it should work then.

HTH

Giles

"Diana" wrote:

I need help. I have price pro hours (exp. 27,03eur/hour) and time written in
one cell in form h:m:s (exp.28:35:00). How can I make formula to multiply and
show total cost (28:35:00*27,03=?. Thanks

How multiply hours and price?
 

=price*time*24

as time is held as a fraction of 1 day.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Diana" wrote in message
...
I need help. I have price pro hours (exp. 27,03eur/hour) and time written
in
one cell in form h:m:s (exp.28:35:00). How can I make formula to multiply
and
show total cost (28:35:00*27,03=?. Thanks