It still is answering as TRUE every time even if I change the time in the formula.

On Friday, May 27, 2016 at 5:39:34 PM UTC-5, Claus Busch wrote:
Hi Allison,

Am Fri, 27 May 2016 15:23:54 -0700 (PDT) schrieb Allison Mazurek:

Unfortunately, it did not. It keeps picking up the first value statment.

=IF(V2<$B$2,0,IF($Z$2TIME(11,30,0),'Current Day Balances'!$B$4-'Current Day Balances'!$D$4,'Current Day Balances'!$F$4-'Current Day Balances'!$D$4))

sorry, I forgot that in Z2 is a military time without colon. You have to
convert it in a regular time. Try:
=IF(V2<$B$2,0,IF(TIME(LEFT($Z$2,2),RIGHT($Z$2,2), 0)TIME(11,30,0),'Current Day Balances'!B4-'Current Day Balances'!D4,'Current Day Balances'!F4-'Current Day Balances'!D4))


Regards
Claus B.
--
Windows10
Office 2016