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

2011-05-31 Terurut Topik fritz saiya
UBSTITUTE(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

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

2011-05-30 Terurut Topik fritz saiya
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