If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Greater than AND Less than Time Q
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Greater than AND Less than Time Q

 Thread Tools Display Modes
#1
March 9th 09, 08:52 AM posted to microsoft.public.excel.worksheet.functions
 Seanie external usenet poster 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, 09:37 AM posted to microsoft.public.excel.worksheet.functions
 Pete_UK external usenet poster 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, 01:12 PM posted to microsoft.public.excel.worksheet.functions
 DILipandey external usenet poster 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(A1>B1,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
>
>
>

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Greater than/Less than a certain Time (revisited) Phrank Excel Worksheet Functions 5 November 26th 06 02:36 PM Greater than/Less than a certain Time Phrank Excel Worksheet Functions 6 November 24th 06 05:14 AM add time greater than 9999:56 PapaT Excel Worksheet Functions 2 March 28th 06 03:48 AM using time functions when hours are greater than 10000 heliheadache Excel Worksheet Functions 1 June 23rd 05 11:55 PM count TIME that is GREATER than 24 hours JonPilot Excel Worksheet Functions 1 January 31st 05 10:55 PM

All times are GMT +1. The time now is 02:26 AM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top