Converting Inches to Feet

[ncar35b]

Help! I can't figure out how to logically convert inches to feet, so the remainder is in inches. For example, I have 37.235 inches. I would like it to be displayed as 3ft 1.235in.

Using the Mod operator would be nice, but it rounds off the numbers!

Thanks for any help.

 

[trollacious]

Try:

Feet = inches \ 12 'note the backslash for integer division
remaininginches = inches - (feet * 12)

Lee

 

[SWarrior]

It's not really that hard... here's the long and short of it... I'm sure you can shorten it, but this is just a quickie!!

inches = 37.235 
feet = int(inches/12)
remainder = (inches-(feet*12))
msgbox("Inches = " & inches & vbCrLf & "Conversion = " & feet & "ft " & remainder & "in.")

-SWarrior

 

[SWarrior]

Dayam !!!!

I didn't know that the \ was for integer division!!
Ya learn something new everyday !!

-SWarrior

 

[dilettante]

[tt]remainder = inches Mod 12[/tt]

 

[dilettante]

Doh!

(repeat after me) "Read thoroughly before inserting foot into mouth.