User inout in 12 hrs format

U

ub

Hi

I want the user to input time in one of the cells in 12 hrs format.
Example, user should only be able to enter 11:00 am or 11:00 pm.
Is there any way to do this.

Thanks
 
T

Tom [Pepper] Willett

Try an Excel newsgroup. This is for FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: Hi
:
: I want the user to input time in one of the cells in 12 hrs format.
: Example, user should only be able to enter 11:00 am or 11:00 pm.
: Is there any way to do this.
:
: Thanks
:
 

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

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Subtracting time...again 2
Input Time in AM/PM 3
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Time format 1
Excel does not accept text format! 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
Calculate hours, past midnight etc 4

Top