Formula for identifying if date/time is after specific time on the day prior to another date/time

[ufka1]

Hi All,

I need some help with an IF formula in identifying if DateTime A is after 12:00pm the day prior to DateTime B then 1,0. For example, if DateTime A is 8/17 12:01 and DateTime B is 8/18 23:00, the formula will flag DateTime A as 1 and if not true then 0.

My data source is dynamic and is constantly updating.

Thank you in advance.

 

[ufka1]

This is what I came up with and it seems to work. =IF([@[DateTimeA]]>(([@[DateTimeB]]-1)+TIME(12,0,0)),1,0)