Good evening! Please tell me why this formula...

(Антон Колобаев) #1

Good evening! Please tell me why this formula always gives me TRUE: IF(OR(AND(NOW() > “005:00:00”, NOW() < “007:00:00”), AND(NOW() > “017:00:00”, NOW() < “019:00:00”)), [ВремяОбхода] = “17:00/05:00”, IF(OR(AND(NOW() > “007:00:00”, NOW() < “017:00:00”), AND(NOW() > “019:00:00”, NOW() < “005:00:00”)), [ВремяОбхода] = “07:00/19:00”, TRUE))

What am I doing wrong?

(Philip Garrett) #2

NOW() returns the Date and Time. It looks like you may want to use TIMENOW().

I did not look at the substance of you expression, so there may be other problem also.

(Антон Колобаев) #3

@Philip_Garrett_Appsh Did not help…

(Антон Колобаев) #4

Условие следующее: AM 5 - 7 = 17:00/05:00 AM7 - PM5 = 07:00/19:00

PM5 - 7 = 17:00/05:00 PM7 - AM5 = 07:00/19:00 Translate