Ticker

6/recent/ticker-posts

Advertisement

convert time to military time vba

Converting to military time Visual Basic .NET. As Scott suggests you can use a custom format to change how time is displayed & parsed. Const militaryTimeFormat As String = "HH:mm" ' convert to a string in military time.

Converting to military time Visual Basic .NET
Converting to military time Visual Basic .NET from chrismenardtraining.com

If you want to do this in Formula (VBA free): =TEXT (C2,"HH:MM"), if all combined with Date and time to be sorted, use something like "YYYY.MM.DD.HH.MM" – PatricK Aug.