dyaron
Active Member
- Joined
- Nov 26, 2007
- Messages
- 291
I want to do this in a cell, not vba.
I have a cell A1, that contains NOW(). It is formatted to show H:MM.
I have another cell B1, that contains a static time in which I test against. It is formatted to show H:MM as well, but the value is actually 17:00
My question is, I'm trying to create in another cell a formula that calculates data based on waht time it is. It's as such:
=if(A1<'B1Sum(A1:A30), Sum(A1:A29)... this doesn't work, because I merely tested to see if the comparison was working by doing the following:
=if(A1<'B1, "A1 is less than B1", "A1 is greater than B1")... and I keep returning the false statement "A1 is greater than B1"), even though this is not the case. Any thoughts?
***ignore that quote after the greater than signs, because the forum wouldn't let me post unless it was there?***
I have a cell A1, that contains NOW(). It is formatted to show H:MM.
I have another cell B1, that contains a static time in which I test against. It is formatted to show H:MM as well, but the value is actually 17:00
My question is, I'm trying to create in another cell a formula that calculates data based on waht time it is. It's as such:
=if(A1<'B1Sum(A1:A30), Sum(A1:A29)... this doesn't work, because I merely tested to see if the comparison was working by doing the following:
=if(A1<'B1, "A1 is less than B1", "A1 is greater than B1")... and I keep returning the false statement "A1 is greater than B1"), even though this is not the case. Any thoughts?
***ignore that quote after the greater than signs, because the forum wouldn't let me post unless it was there?***
Last edited: