Excel conversion functions?

I am not aware of an off-the-shelf solution. Hopefully someone has an easier way, but here’s how I approach the question:

1)
The INT function will give you the whole number (41)
=INT(41.8001)

2)
MOD gives the remainder (0.8001)
=MOD(41.8001,1)

3)
INT and MOD will give you inches (9)
=INT(MOD(41.8001,1) * 12)

And I’ve never done fractions, but here’s a page about it:
www.mrexcel.com/articles/display-fractions-in-excel.php

Sorry to give an incomplete answer, but that’s all I have time for this morning.

I have written an Excel macro that does fractional inch to decimal inch conversions (and back to fractional inch). If you’ll PM me with an email address I’d be happy to send you the file that contains it, with simple instructions for use.