A awais May 20, 2008 #1 how can i feed time in military format? e.g. 1210 for 12:10 PM, 1740 for 17:40 PM, 0030 for 12:30 AM.
how can i feed time in military format? e.g. 1210 for 12:10 PM, 1740 for 17:40 PM, 0030 for 12:30 AM.
R Roger Govier May 20, 2008 #2 Hi take a look at Chip Pearson's site http://www.cpearson.com/Excel/DateTimeEntry.htm