Posted to microsoft.public.excel.misc

external usenet poster

Posts: 120

Input Time in AM/PM

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
negative time input	Big Mac	Excel Worksheet Functions	5	January 3rd 08 03:57 PM
User time input	Renegade40	Excel Worksheet Functions	12	July 5th 07 12:56 AM
How to input 'Used time' data ?	Patrick Chan	Excel Worksheet Functions	2	November 7th 06 06:04 AM
Time Input	Michael	Excel Discussion (Misc queries)	5	February 10th 06 07:20 PM
can you input time (hh:mm:ss) without having to input the colon i.	Lexicon	Excel Discussion (Misc queries)	4	January 11th 05 02:09 PM

All times are GMT +1. The time now is 03:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us