Is there an XLS function to convert std time to Military time?
D David Biddulph May 20, 2009 #2 If you want 18:57 to appear as 1857, then you could use =TEXT(A1,"hhmm")
