data validation
 

How to set data validation for user to key in 24H time format?

data validation
 

if the user entered 10:30

how would you know?

if the user entered 10:30 PM why not just store it and format the cell as h:mm

--
Regards,
Tom Ogilvy


"crapit" wrote:

How to set data validation for user to key in 24H time format?

data validation
 

Any way to restrict ?
I did try to use

allow :- "whole number"
data :- " between"
minimum: 0000
maximum: 2400
but user can also key in value 2360, 1299 which is not a time value

"Tom Ogilvy" wrote in message
...
if the user entered 10:30

how would you know?

if the user entered 10:30 PM why not just store it and format the cell as
h:mm

--
Regards,
Tom Ogilvy


"crapit" wrote:

How to set data validation for user to key in 24H time format?