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