Help with IF Function for times.

R

Ryanoo

Hello

I hope you are all well and this is in the correct section

I have a problem with an IF command

------------------------------------------------------------------------------
Details

-EXCEL 201

-All cells containing times are custom formatted to show hh:m

A1 - IF formula
B1 - Contains a formula that displays an average time for a range o
cells
C1 - Contains [=now] for current time

----------------------------------------------------------------------------------

Basically I would like A1 to check if the current time (c1) is late
than B1.
If the argument is true (if C1 is later than B1) it should retur
Available
If it is false (not later) then it should return un-available.

Thanks in advance
Ryan
 
C

Claus Busch

Hi,

Am Thu, 21 Feb 2013 05:02:12 +0000 schrieb Ryanoo:
Basically I would like A1 to check if the current time (c1) is later
than B1.
If the argument is true (if C1 is later than B1) it should return
Available?
If it is false (not later) then it should return un-available.

try:
=IF(MOD(C1,1)>B1,"Available?","Unavailable")


Regards
Claus Busch
 
S

Spencer101

Ryanoo;1609558 said:
Hello,

I hope you are all well and this is in the correct section.


I have a problem with an IF command.

-------------------------------------------------------------------------------
Details;

-EXCEL 2010

-All cells containing times are custom formatted to show hh:mm

A1 - IF formula.
B1 - Contains a formula that displays an average time for a range o
cells.
C1 - Contains [=now] for current time.

-----------------------------------------------------------------------------------

Basically I would like A1 to check if the current time (c1) is late
than B1.
If the argument is true (if C1 is later than B1) it should retur
Available?
If it is false (not later) then it should return un-available.


Thanks in advance,
Ryan.

=IF(C1>B1,"Available","Unavailable")

But you don't really need the value in C1. You cold just have

=IF(NOW()>B1,"Available","Unavailable"
 
C

Claus Busch

Hi Spencer,

Am Thu, 21 Feb 2013 10:10:12 +0000 schrieb Spencer101:
But you don't really need the value in C1. You cold just have

=IF(NOW()>B1,"Available","Unavailable")

NOW() is date + time and it is always greater than a time.
Just in this moment NOW is 41326,6111829861
and CTRL+SHIFT+Point = 0,6111829861


Regards
Claus Busch
 
R

Ryanoo

Claus said:
Hi Spencer

Am Thu, 21 Feb 2013 10:10:12 +0000 schrieb Spencer101


NOW() is date + time and it is always greater than a time
Just in this moment NOW is 41326,611182986
and CTRL+SHIFT+Point = 0,611182986


Regard
Claus Busc

Hi Claus, thanks very much for your reply

Your formula works if I remove =now() and manually enter the time

I misrepresented what I put earlier, I have a D1 cell that contain
-'=now()'- and a C1 that contains -'=D1'-, which is probably pointless

Is there a correct way of referencing =now() without it impairing th
formula

In regards to =now being '41326,6111829861' what do you mean

Many Thanks
Rya

Edit: Just read about serial number values etc. so I understand tha
value
 
C

Claus Busch

Hi,

Am Thu, 21 Feb 2013 23:02:56 +0000 schrieb Ryanoo:
I misrepresented what I put earlier, I have a D1 cell that contains
-'=now()'- and a C1 that contains -'=D1'-, which is probably pointless.

try:
=IF(MOD(C1,1)>B1,"Available?","Unavailable")


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top