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
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