Maaf lampirannya tertinggal..
From: Dede [mailto:pmaho_l...@nabatisnack.co.id] Sent: 20 Februari 2015 16:38 To: 'belajar-excel@yahoogroups.com' Subject: RE: [belajar-excel] Waktu Dear Mr. Kid, dan BeExceler, Terimakasih atas pencerahannya, namun ada sedikit masalah pada sheet “Rekap” cell C6. Dan satu lagi mohon bantuannya untuk sheet “Form”, bagaimana seting data validationnya. Salam, DD From: 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 20 Februari 2015 15:36 To: BeExcel Subject: Re: [belajar-excel] Waktu Coba formula : (untuk berangkat) -> regional setting komputer english ya =IF(B3<1,B3,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3,"'",":"),"""",":"),".",":"),",",":")*1) Wassalam, Kid. On Fri, Feb 20, 2015 at 6:48 PM, Dede pmaho_l...@nabatisnack.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Dear Be Exceler, Mohon bantuan dari rekan-rekan sekalian terkait kasus terlampir. Salam, DD _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
Convert Time.xlsx
Description: MS-Excel 2007 spreadsheet