ExcelBanter - convert feet & inches to decimals

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

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

- - convert feet & inches to decimals (https://www.excelbanter.com/excel-worksheet-functions/195740-convert-feet-inches-decimals.html)

Roderick

convert feet & inches to decimals

example: I need to insert 3'-2" into one cell and the result shown in another
cell would be the equivalent in decimals of feet
--
Estimator

Teethless mama

convert feet & inches to decimals

=LEFT(A1,FIND("-",A1)-2)+SUBSTITUTE(MID(A1,FIND("-",A1)+1,5),"""","")/12

"Roderick" wrote:

example: I need to insert 3'-2" into one cell and the result shown in another
cell would be the equivalent in decimals of feet
--
Estimator

All times are GMT +1. The time now is 01:21 PM.