Function to convert feet and inchs into decimal equivalents

[Chuck Bierwirth]

I have several thousand cells of infomation in feet and inchs I need to be
able to do calculations on which I think I can only do by converting them
into their decimal equivalents.

Does anyone know a function or some other way to convert these?

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/fractional.htm

 

[Ron Rosenfeld]

I have several thousand cells of infomation in feet and inchs I need to be
able to do calculations on which I think I can only do by converting them
into their decimal equivalents.

Does anyone know a function or some other way to convert these?

Exactly what is in the cells?


--ron