Forum Discussion
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.
Thanks!
1. Is ">--" means after and "<--" before?
2. Will it work in other formulas?
3. The option you suggested does not count the exact time 22:00:00 in the range,
Is there a way to include it in (like "=>" in math)?
Thanks again!
< means smaller than, > means greater than and -- is a type conversion from text to number because the time is set in double quotes which means Excel regards it as text.
If you want to include the lower and upper boundaries change < to <= and > to >=.
