A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
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  
Old March 9th 09, 08:52 AM posted to microsoft.public.excel.worksheet.functions
Seanie
external usenet poster
 
Posts: 202
Default 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


Ads
  #2  
Old March 9th 09, 09:37 AM posted to microsoft.public.excel.worksheet.functions
Pete_UK
external usenet poster
 
Posts: 8,856
Default 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  
Old March 9th 09, 01:12 PM posted to microsoft.public.excel.worksheet.functions
DILipandey
external usenet poster
 
Posts: 70
Default 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

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

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 05:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.