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

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

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?
>
>
>

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" <TomOgilvy@discussions.microsoft.com> wrote in message
news:0E7B4ACA-F373-4D2D-820F-4103BC0A1910@microsoft.com...
> 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?
>>
>>
>>