Remember Me?

#1
March 9th 09, 09:52 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 202
Greater than AND Less than Time Q

How could I construct a formula that checks if the Current Time is
Greater than 7:00pm and Less than 12:00am

#2
March 9th 09, 10:37 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856
Greater than AND Less than Time Q

12:00am meaning midnight?

Try this:

=IF(TIME(A1)19/24,"yes","no")

No need to test for the other condition.

But, if you were interested in, say, times greater than 7:00pm and
times less than 10:00pm, then you would have this:

=IF(AND(TIME(A1)19/24,TIME(A1)<22/24),"yes","no")

Note the use of the 24-hour clock.

Hope this helps.

Pete

On Mar 9, 8:52*am, Seanie wrote:
How could I construct a formula that checks if the Current Time is
Greater than 7:00pm and Less than 12:00am

#3
March 9th 09, 02:12 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: May 2008 Posts: 70
Greater than AND Less than Time Q

Hi Seanie,

Assuming you have the current time in cell A1, write 7:00:00 PM in B1 and
11:59:59 PM in B2. After entering, both of them will appear as
19:00
23:59, respectively,

Now apply the following formula.

=IF(AND(A1B1,A1<B2),"Yes","No")
Hope it helps.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)

New Delhi, India

"Seanie" wrote:

How could I construct a formula that checks if the Current Time is
Greater than 7:00pm and Less than 12:00am

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Phrank Excel Worksheet Functions 5 November 26th 06 03:36 PM Phrank Excel Worksheet Functions 6 November 24th 06 06:14 AM PapaT Excel Worksheet Functions 2 March 28th 06 03:48 AM heliheadache Excel Worksheet Functions 1 June 23rd 05 11:55 PM JonPilot Excel Worksheet Functions 1 January 31st 05 11:55 PM

All times are GMT +1. The time now is 10:02 PM.