Posted to microsoft.public.excel.misc

Demosthenes Demosthenes is offline

external usenet poster

Posts: 36

Time input simplification

Hi,

I want to set up a worksheet so that an input of "9a" or "1p" will
autocorrect to "9:00 AM" and "1:00 PM." What's the best way to do that?

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
Formula Simplification Please ...	Ken	Excel Discussion (Misc queries)	6	May 9th 09 08:24 AM
Simplification of Matrix	Tuppie11	Excel Discussion (Misc queries)	5	October 23rd 08 02:48 PM
Simplification help	Mike Smith NC	Excel Worksheet Functions	3	July 12th 06 06:28 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
formula simplification	Todd	Excel Worksheet Functions	2	October 28th 04 01:49 AM

All times are GMT +1. The time now is 12:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us