C
cozturk via AccessMonster.com
Sorry, my brain got totally dead on this.
I have a form converting metric to US units and vice versa. for converting
height in format ft'in" (such as 5'3") to cms, I simply used =([ft]*30,48)+(
[in]*2,54) formula. Stuck on doing vice versa. I need to divide the cms by 30.
48 to get the feet value, then extract the remainder and convert to inches.
for example, 163 cms = 5.34 feet. I need to get the 5 feet on one hand and
convert the .34 to inches by multiplying it with 12 which will make 5 feet 4
inches.
I just couldn't & appreciate any assistance
Thanks in advance,
Celal
I have a form converting metric to US units and vice versa. for converting
height in format ft'in" (such as 5'3") to cms, I simply used =([ft]*30,48)+(
[in]*2,54) formula. Stuck on doing vice versa. I need to divide the cms by 30.
48 to get the feet value, then extract the remainder and convert to inches.
for example, 163 cms = 5.34 feet. I need to get the 5 feet on one hand and
convert the .34 to inches by multiplying it with 12 which will make 5 feet 4
inches.
I just couldn't & appreciate any assistance
Thanks in advance,
Celal