Thread: Military time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Military time

Rember that a time is entered as 13:30, not 1330.
--
David Biddulph


RM270 wrote:
I have a large list I am working with. One column lists the hours
worked as military time ( 0900-1200, 1330-1540). Is there a way to
format the cell to turn a color, or pop up an error message if the
entry does not match the military time format, as well as the to and
from time? I want to be able to easily spot an entry that may have
been typed in wrong, like 130 instead of 1330.

Thanks for any help provided.