Coba formula : =DATE(MID(B4,7,5),FIND(LEFT(B4,3)," JanFebMarAprMayJunJulAugSepOctNovDec")/3,MID(B4,5,2))+TRIM(LEFT(RIGHT(B4,7),5))+12/24*(RIGHT(B4,2)="PM")
Jika setting regional komputer Anda Indonesia (pemisah angka ribuan adalah titik), ganti semua koma dalam formula menjadi titik koma. Wassalam, Kid. 2013/3/6 Fahmi Baskara Gmail <fahmi.bask...@gmail.com> > ** > > > Dear Para master Excel…**** > > Mohon bantuannya para master untuk mengubah format text menjadi format > date seperti contoh di bawah ini.**** > > *Date (Text)* > > *Hasil Konversi* > > Jan 17 2013 3:59PM**** > > 1/17/13 15:59**** > > Feb 23 2013 2:51PM**** > > 2/23/13 14:51**** > > Mar 16 2012 12:35PM**** > > 3/16/12 0:35**** > > Apr 28 2012 8:28AM**** > > 4/28/12 8:28**** > > May 31 2012 10:04PM**** > > 5/31/12 22:04**** > > Jun 5 2012 7:38AM**** > > 6/5/12 7:38**** > > Jul 23 2012 8:47AM**** > > 7/23/12 8:47**** > > Aug 23 2012 8:13AM**** > > 8/23/12 8:13**** > > Sep 3 2012 9:46AM**** > > 9/3/12 9:46**** > > Oct 2 2012 3:46PM**** > > 10/2/12 15:46**** > > Nov 7 2012 9:47AM**** > > 11/7/12 9:47**** > > Dec 30 2012 9:56PM**** > > 12/30/12 21:56**** > > ** ** > > Saya lampirkan juga file-nya**** > > **** > > >
