How to Convert from Military to Standard Time in Excel

Many people ask for my help to convert time values that display as military time (1700 hours) to standard time 5:00 PM). If the time value is "stored" as a number, this is easy - you just change the formatting for the cells. However, if the time values is "stored" as a "text value," you will have to take a few steps to make the conversion.

Watch, as I demonstrate each step in this process. I use the LEFT, RIGHT and TIMEVALUE Functions in Excel. I also show you how to join text strings using the & (ampersand).

Please visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to sample all of my services.

Danny Rocks
The Company Rocks

Category:

Education

Tags:

• Excel
• Change Text Values to Numbers
• Time Formats
• Military Time
• Software Tutorial
• Educational
• Business
• Computer Software
• Management
• Technology
• Office
• Microsoft Excel
• Data
• Microsoft Office
• Training
• Information

[DannyRocksExcels]

@zenubio01

My pleasure! I am pleased that you found my video helpful.

Danny Rocks

The Company Rocks

[zenubio01]

Thanks for the video. Very helpful

[DannyRocksExcels]

@kiefjan24

Thank you Janet. I am so pleased that I could help you. Thanks for taking the time to write.

Danny Rocks

The Company Rocks

[kiefjan24]

This is a great video. i understood it and tried it. Works perfectly. thanks for sharing.

Janet

[DannyRocksExcels]

@fride360360

Thank you for writing to tell me. I am so pleased that I could help you.

Danny Rocks

The Company Rocks

[fride360360]

Great video, I learned a lot!!