Cell Formats and Formulas
Posted by Becky on July 24, 2001 1:45 PM
Good Day.
How can I multiply 8:00 (hours) in one cell times $11.00 in another and have it show me the total in dollars ($88.00)?
Posted by Aladin Akyurek on July 24, 2001 1:50 PM
Use:
=B1*(HOUR(A1)+MINUTE(A1)/60)
Number or general format the cell of this formula.
Aladin
Posted by Aladin Akyurek on July 24, 2001 3:55 PM
Make that B1 just $11.00.
Posted by Ian on July 25, 2001 8:02 AM
or
you could use:
=(B1*24)*C1
Posted by Aladi Akyurek on July 25, 2001 8:24 AM
Re: or
The shorter the better.
Aladin
Posted by Becky on July 27, 2001 11:49 AM
Re: or
Thank you very much!
Becky
