rumus di H10
=SUMPRODUCT(B11:D11/{1,60,60000})/24kemudian atur format number : [h]° mm' ss.00\" untuk menampilkan format ddd mm' ss,ss" semoga sesuai yang diharapkan From: [email protected] [mailto:[email protected]] Sent: Monday, November 10, 2014 6:25 PM To: [email protected] Subject: [belajar-excel] geotaggging converter [1 Attachment] hallo para master excel, minta tolong gimana caranya convert geotagging yang berformat "ddd mm.mmm" ke format "ddd mm' ss,ss" contoh terlampir. Terima kasih. caax
Copy of geotag.xlsx
Description: MS-Excel 2007 spreadsheet

