RE: [belajar-excel] perubahan text angka pecahan ke angka decimal

[zainul ulum [yahoo]]

Misal data yang akan diconvert di A2

=--SUBSTITUTE(LEFT(A2,FIND("-",A2)-1)&"'","'","")+SUBSTITUTE(MID(A2,FIND("-"
,A2)+1,99),CHAR(34),"")/12

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
On Behalf Of fritz saiya
Sent: Tuesday, May 31, 2011 1:37 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] perubahan text angka pecahan ke angka decimal

 

  

Dear Be-excel ,

Saya mau konversi text angka pecahan ( feet ) ke angka decimal ( feet ),
bagaimana caranya ??? seperti contoh di bawah ini :

 


377'-11"

to 

377.91667


382'-5 11/16"

to 

382.47396


379'-10 7/8"

to 

379.90625


378'-1/16"

to 

378.00521

 

Terima kasih,

FSaiya

 

<<image001.jpg>>

<<image002.jpg>>

feet-inch to feet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet