Redundant 1, twice<bg

=LEFT(A1)*40&" Hours"
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"CLR" wrote in message
...
=LEFT(A1,1)*1*40&" hours"

Vaya con Dios,
Chuck, CABGx3



"text and formulas" <text and wrote in
message ...
how do i make a calculation if a cell has text and a number. Example the
cell
says "3 weeks" I want to calculate 3 weeks to read in the next column as
"120
hours"