Posted to microsoft.public.excel.programming

Ian M[_2_] Ian M[_2_] is offline

external usenet poster

Posts: 15

Time function in Excel

How can I programme an individual cell in an Excel spreadsheet to
perform a task depending on what time is entered into it.

i.e. if any time is entered which falls between 12.00 noon and 1.30
pm, I want a message box to appear saying "Remember to Order Lunch".

Any ideas?

Thanks for your help.

Kind regards

Paddymichelle

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
Macro / function text time to 24hr excel time passed midnight fortotaling hr's	Russmaz	Excel Worksheet Functions	2	March 6th 09 04:58 AM
Excel Time Function	Rich	Excel Worksheet Functions	3	January 27th 09 05:20 PM
HOW DO I KEEP THE FUNCTION BOX OPEN ALL THE TIME IN EXCEL?	JEG	Excel Discussion (Misc queries)	1	August 14th 07 02:42 PM
Why won't the SUMIF function in Excel add time?	SKHRAANENMOENR	Excel Worksheet Functions	2	January 25th 07 07:46 PM
TIME function used in Excel	jeramy	Excel Worksheet Functions	1	July 2nd 05 02:59 AM

All times are GMT +1. The time now is 06:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us