Length Convertion Calculation

[surwoop]

I'm trying to write a calc that will convert mm to feet & inches without much luck. No problem converting to feet OR inches but that wont do.

eg.

1600mm = 5'3" not 1600mm = 5.25

Any tips?

FileMaker Version: Dev 6

Platform: Mac OS X Panther

[BobWeaver]

Inches = Round(millimeters / 25.4, NumDecimalPlaces)

FeetNinches = Int(Inches / 12) & "'" & Mod( Inches,12) & """"

[surwoop]

Doh!

Thanks Bob