BEFORE READING THIS ARTICLE , IT IS REQUESTED TO VISIT THE PART I WHICH DISCUSSES THE CONCEPT OF THE DATE AND TIME IN EXCEL FOR BETTER UNDERSTANDING.CLICK HERE TO VISIT.
Before we start working upon the MILITARY TIME, it is important to understand what it is.
MILITARY TIME is a very old time format, which of course is not as popular as our standard 12 hrs time format.
MILITARY TIME IS LIKE 24 HRS TIME FORMAT WITH THE COLON [:] MISSING BETWEEN THE HRS AND MINUTES.
The origin of military time has been found way back to 2100 BC found through the archaeological evidences in the Egypt.
The military time is not very popular in day to day and normal jobs but there are many areas where we prefer using this time. For example
MILITARY TIME is expressed as the 24 hour time but without the colon [:]. There is no separator between the hours and minutes.
For example 1 AM as 0100 and 10:30 pm AS 2230. So the time ranges from 0000 to 2359.
Let us find out the conversion of NORMAL TIME to MILITARY TIME and MILITARY TIME to NORMAL TIME.
CONVERT STANDARD TIME TO MILITARY TIME:
We can convert it simply using the TEXT FUNCTION.
We have the following challenges before we convert the military time to standard time in Excel
STEPS TO CONVERT MILITARY TIME TO STANDARD TIME.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE