Prev: File Search Excel 2003
Next: Shapes on Worksheets Move And Resize
From: RM270 on 17 Feb 2010 21:50
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.
From: "David Biddulph" groups [at] on 17 Feb 2010 22:42
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.


 | 
Pages: 1
Prev: File Search Excel 2003
Next: Shapes on Worksheets Move And Resize