Time x Rate
Try this:
=E46*24*E47
Format as General, Number or Currency
--
Biff
Microsoft Excel MVP
"Scott A" wrote in message
...
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
|