Data validation question

  • Thread starter Thread starter JVS
  • Start date Start date
J

JVS

I'm trying to use data validation for time but I am only able to set the
range from
0:00 to 11:59pm. I'd like to set the range from 0:00 to 24:59.
Is this possible?

Thanks!
Johnny
 
Johnny,

You can set it to 00:00 to 23:59, but not 24:59 as that is not a valid time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top