Route in Excel for Logbook

[kitercuda]

Díky za inspiraci. Asi to talčítko Donate udělám, s aplikaci trávím 90 procent svého pracovního času, ale představuje tak do 10% mých příjmů. Dělám to jen, protože mě to baví

[FIFFAN]

Dear kitercuda,

I am trying to customize .xls Navigation Log and following your instructions in manual.

Everything goes well but when I export routes in "FIF_compact.xls" form I cant get coordinates in "raw_data" sheet in MGRS format.
MGRS format of coordinates is selected in App settings / Preferences / Units select / Geographical coordinate unit / MGRS 10 digit grid and used without problems in Fly is Fun application on android device.

In "raw_data" sheet in section with Units and its formats it stands Coordinates 34UBA 93921 67312

And down where at route details are "Decimal latitude" & "Decimal longitude" columns with D.DDDDD formats and "Latitude" & "Longitude" columns with 34UBA 93921 67312 format. But regardless all the coordinates in all those rows are in D.DDDDD format.

How can I get MGRS format in "Latitude" & "Longitude" columns? I believe it has to be possible.
Also, is it possible to get that data in DDD:MM:SS.SS and MGRS formats in the "raw_data" sheet simultaneously?

Additional question, in "raw_data" sheet all times in EET columns are in hh:mm format, is it possible to get it in hh:mm:ss format ?

Thank You in advance,
Best regards!

[kitercuda]

Díky, mrknu na to...
Jestli se můžu zeptat, s čím v Avganistánu lítáte?