I'm not sure if this is possible, but is there a formula I can enter a time in military time (ex: 0230) and have it automatically display as standard time (ex: 2:30 AM)? Basically I'm looking for a quick way to enter times into my spreadsheets without having to type the format every time.
Thanks.
Thanks.