View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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