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)

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!