Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with IF Function for times.
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 of cells. C1 - Contains [=now] for current time. ----------------------------------------------------------------------------------- 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. Thanks in advance, Ryan. Last edited by Ryanoo : February 21st 13 at 05:03 AM Reason: Deleted repeated line. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speeding up this code- when a custom function is used many times | Excel Programming | |||
Question on the countif function and times | Excel Worksheet Functions | |||
Function for stopwatch times | Excel Worksheet Functions | |||
Need help with custom function that deals with times | Excel Worksheet Functions | |||
How can use IF function more than 7 times in a cell | Excel Worksheet Functions |