I have the following formula 

Please Login or Register  to view this content.
my issue is, is that when the date/time is the same as the one above (even though what is in H:H doesn't match what's in D#) it uses what is listed first. idk its weird. has anyone else had this happen to them before?