Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Change time format

Posted by Squirrel on February 23, 2001 5:54 PM

Is there a way to type time in as 10:30p and the cell turns it to mil. time (22:30)

Re: Change time format

Posted by Robert on February 23, 2001 7:07 PM

1. Highlight the cells that you want to convert to miliary time.
2. Format the cells with one of the following TIME formats: 13:30 or 13:30:55, as listed in the TIME category of cell formats.
3. Make sure you type a space after the time for AM or PM. (e.g. '10:30 PM', '10:30 P', '10:30 p', and '10:30 pm' are all valid, but '10:30PM', '10:30P', '10:30p', and '10:30pm' are not valid)

Voila!

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.