MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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