How to Convert from Military to Standard Time in Excel

Published: 15 February 2011
on channel: Danny Rocks

31,317

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

Watch video How to Convert from Military to Standard Time in Excel online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 15 February 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 31,317 once and liked it 53 people.

3,654