Excel: DTG Converter

Military Date Time Group

A form of DTG is used in the US Military's message traffic (a form of Automated Message Handling System). In US military messages and communications (e.g., on maps showing troop movements) the format is DD HHMMZ MON YY. Although occasionally seen with spaces, it can also be written as a single string of characters.

Example 1: 09 1630Z JUL 11 represents (Jul) 09 16:30 Jul 2011 (UTC).

Example 2: 19 0513Z Feb 20 represents (Feb) 19 05:13, Feb 2020 (UTC).

Attached is an Excel spreadsheet that does this conversion for Australian AEST.

I've created a spreadsheet that can do this conversion.

To find out what your time zone uses, see the following:

https://en.wikipedia.org/wiki/Daylight_saving_time_by_country