rumus di H10

=SUMPRODUCT(B11:D11/{1,60,60000})/24

 

kemudian 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



Attachment: Copy of geotag.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke