Using IF with hour formed cells.

I need to make a condition: If entrance hour is between 22:00 and 05:00... How can I do it using if or ifs formula? Excel 365 Thanks.

if in hours.xlsx9 KB

excel

Formulas and Functions

NikolinoDE

Platinum Contributor

Nov 07, 2020

itaytr

I know I don't know anything (Socrates)

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

* Knowing the Excel version and operating system would also be an advantage.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)