Posted to microsoft.public.excel.misc

Posts: n/a

use the current time to return a value

Simple formula? if the time is =07:00:00<15:00:00, G$1. = 1 if time
=15:00:00 < 23:00:00 G$1 = 2 if Time =23:00:00 < 07:00:00 G$1 = 3

I have tried to do this a few different ways and have been
unsuccessful. Could someone help please?

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
Entering Times	Denise	Excel Discussion (Misc queries)	9	November 15th 05 04:57 PM
Time and motion chart	deant	Charts and Charting in Excel	0	September 21st 05 08:22 AM
Excel Time Manipulation	BFiedler	Excel Discussion (Misc queries)	0	September 15th 05 01:15 AM
Using "IF" and "AND" statements with current time	Bill	Excel Worksheet Functions	3	April 18th 05 08:21 PM
Calculating tvl time in Excel 2000 Rev.9.2720	Brandi	Excel Worksheet Functions	5	January 27th 05 09:15 PM

All times are GMT +1. The time now is 07:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us