Thread: How do i convert feet and inches to a decimal value?
View Single Post
  #1   Report Post  
go_chrisg
 
Posts: n/a
Default How do i convert feet and inches to a decimal value?
I have an assignment that shows me this equation but it doesnt seem to
work,
=LEFT(A1,FIND("",A1)-1)+((MID(A1,FIND("",A1)+1,LEN(A1)-FIND("",A1)-1))/12)
Reply With QuoteReply With Quote