Thread: Time x Rate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott A[_2_] Scott A[_2_] is offline
external usenet poster
 
Posts: 57
Default Time x Rate

Hello,

I need help with a formula to multiply time by a rate amount.

I have the time calculating and shows in a [hr]:mm format (in one cell) and
am trying to multiply it by a rate of $45.00 per hour(in another cell).

A B C D E
46 28:30
47 $45.00
48 ?

I have tried several formulas but none have worked.

Thank you for your help!

Scott A