TIME

U

ub

Hi

Is it possible to place a check on a cell that user can only enter time 1-12
hrs time format and noy 1-24 hrs format.

Example, he should be able to input from 1-12 , but not from 13 to 24
 
J

John C

Please do not multi-post, you have responses in your other post (the one in
the excel newsgroup, not the one in the frontpage newsgroup), that you have
yet to respond too. Just curious, what is the problem if the person enters a
time in 24 hour format. If you have the cell formatted for am/pm, after the
person enters, the time will convert to 12 hour format. Without more
information, no one can really help you. And please, if you do respond to my
question, please answer in your original question, and do not continue the
double (/triple) post of the same question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input Time in AM/PM 3
Group Time 3
Vacation Date Problem 5
help cumulative hrs 1
overtime calculation 1
elapsed dates between start and end date and time 2
Extracting time (hr:min) from date/time format 2
formula or calculation for adding negative hour and positive hours 1

Top