Hi all. I need a formula that looks at the current time and can determine whether that time is between two other times. It needs to be dynamic. What I did was create a Start Time (col F) and a Grace Period (col G) which varies by line and always has a 15 min. spread between the two. In col K, I entered =Now() to get the current time (understanding that this needs to be recalced). I then created a col H current Schedule to act as a flag of either True or False if the current time falls (or doesn't fall) between the Start Time and Grace Period. However it only returns False. Here is the formula I am using: =IF(AND($K$2>=F2,$K$2<=G2),TRUE, FALSE) I think the problem is when the formula is evaluating $K$2 that even though the actual time is displayed it is interpreting the contents of the cell as =Now() and that doesn't compute against the time range. I think this because if I key in an actual time in K2 the formula works fine.
So that was a long winded way of saying is there a way to insert in a formula a reference to the actual result another formula returns rather than the actual formula itself?
Thanks in advance!
Lou
So that was a long winded way of saying is there a way to insert in a formula a reference to the actual result another formula returns rather than the actual formula itself?
Thanks in advance!
Lou