On 18:21 Mon 18 Jun , JosephK wrote:
> On 17:35 Mon 18 Jun , Harold Fuchs wrote:
> > I'm using OO2.2 on Win XP2.
> > How do I get a column in Calc to display feet and inches as per, for
> > example 3'9" but still be able to do arithmetic on the value, treating
> > this example as 3.75 feet? I don't mind if the inches symbol (") is not
> > shown but the feet symbol (') must show. So far about the best I can do
> > is to have the feet in one column, a quote in the second column and the
> > inches in the third with no border between them and the columns made as
> > narrow as possible. Please tell me there's a better way.
> >
>
> Do the calculations in inches. If A1 holds the number of inches then you
> need something like
> =CONCATENATE(TEXT(INT(A1/12);"##'");TEXT(MOD(A1;12);"##''"))
>
> HTH
To do the reverse try (assuming 12'10'' or whatever is in f1)
=VALUE(LEFT(F1;FIND("'";F1)-1))*12+VALUE(MID(F1;FIND("'";F1)+1;LEN(F1)-FIND("'";F1)-2))
Using a single quote for the feet and 2 single quotes for the inches.
Regards
--
It is often safer to be in chains than to be free.
Joseph K
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
