Comparing current time to the time in the past and the future

[Brennivin]

Hi,

It is currently 11.40 AM. When I evaluate

?Now() > TimeSerial(11,30,0)

I get True.

However, when I evaluate

?Now() < TimeSerial(11,50,0)

I get False.

Why is this?

 

[gsistek]

Now() is the current system date and time.
Try using Now()-Date > TimeSerial(11,30,0)

 

[Jonmo1]

Perhaps

?Time < TimeSerial(11,50,0)

 

[Brennivin]

Now() is the current system date and time.
Try using Now()-Date > TimeSerial(11,30,0)

Now() > TimeSerial(11,30,0) is True -- it evaluates correctly. There's something about the less than condition that doesn't evaluate correctly.

 

[Jonmo1]

Because NOW() is DATE + TIME, while TIMESERIAL(...) is just time.
Dates are Whole numbers incrimenting by 1 since Jan 1 1900
Jan 1 1900 = 1
Jan 2 1900 = 2
etc
Mar 27 2013 = 41360

TIMES are Decimal Numbers (Fractions of 1)
6AM = 0.25
NOON = 0.5
6PM = 0.75

DATE + TIME = Whole Number + Decimal.
So Mar 13th 2013 at 6PM = 41360.75

Put =NOW() in 1 cell and =TIME(11,30,0) in another.
And format those cells as a number with 6 or more decimals.
You'll see the difference.

 

[Jonmo1]

So Mar 13th 2013 at 6PM = 41360.75

That should have read Mar 27th 2013 at 6PM

 

[Brennivin]

That should have read Mar 27th 2013 at 6PM

Hi Jonmo, thanks for your response, but my issue is that the greater than comparison works, but the lesser than comparison doesn't, when I'm comparing Now() against TimeSerial. Sorry I should've been more specific in my original post.

 

[Jonmo1]

Hi Jonmo, thanks for your response, but my issue is that the greater than comparison works, but the lesser than comparison doesn't, when I'm comparing Now() against TimeSerial. Sorry I should've been more specific in my original post.

No, you expressed your concern quite clearly and it was understood.

You're not understanding the answer.


NOW() will ALWAYS be greater than any value returned by TIMESERIAL
Because NOW is equal to TODAY(41360)+CurrentTime(a decimal number less than 0)
But TIMESERIAL is a number less than 0 (a fraction of 1 day)


Here's some results given from my immediate window

?Now()
3/27/2013 1:10:58 PM
?Timeserial(15,30,0)
3:30:00 PM
?cdbl(now())
41360.549525463
?Cdbl(timeserial(11,30,0))
0.479166666666667
?now() > timeserial(15,30,00)
True

 

[Brennivin]

No, you expressed your concern quite clearly and it was understood.

You're not understanding the answer.


NOW() will ALWAYS be greater than any value returned by TIMESERIAL
Because NOW is equal to TODAY(41360)+CurrentTime(a decimal number less than 0)
But TIMESERIAL is a number less than 0 (a fraction of 1 day)


Here's some results given from my immediate window

?Now()
3/27/2013 1:10:58 PM
?Timeserial(15,30,0)
3:30:00 PM
?cdbl(now())
41360.549525463
?Cdbl(timeserial(11,30,0))
0.479166666666667
?now() > timeserial(15,30,00)
True

Ohhh, I get it. Awesome. Thanks a lot!

 

[Jonmo1]

Glad to help, thanks for the feedback.