ExcelBanter - Function to convert feet and inchs into decimal equivalents

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function to convert feet and inchs into decimal equivalents (https://www.excelbanter.com/excel-worksheet-functions/7711-function-convert-feet-inchs-into-decimal-equivalents.html)

Chuck Bierwirth

Function to convert feet and inchs into decimal equivalents

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Chuck Bierwirth" schrieb im
Newsbeitrag ...
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?

Ron Rosenfeld

On Thu, 9 Dec 2004 11:18:46 -0800, Chuck Bierwirth
wrote:

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

All times are GMT +1. The time now is 03:41 PM.