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.
When the admission hour is between 10:00 PM and 5:00 AM ... what should happen here?
Excel is from the Arabic or Hebrew region.
From right to left.
In your Excel sheet you only have these lines
| entering hour |
| 22:00:00 |
| 19:00:00 |
| 23:15:00 |
| 06:00:00 |
| 04:15:00 |
... what should become of them?
... and as already written, please state the Excel version and operating system,
if possible exactly (e.g. Excel 365 Pro or Win10-2004).
Forgive us for the circumstances, but if no precise task can be set and no precise instructions can be given, then in the best case, only an imprecise solution can be suggested to you.
Thanks for your patience and understanding
Nikolino
I know I don't know anything (Socrates)
Hi Nikolino,
I updated the file and added a column with what I want to achieve.
I'm using excel in my android phone.
I'll try to be specific about what I want:
I want a formula to tell me if the entrance time is between 22:00 and 05:00.
If the answer to the above is yes - I want a "yes" as a outcome.
It is excel for Hebrew.
I updated the file and added a column with what I want to achieve.
I'm using excel in my android phone.
I'll try to be specific about what I want:
I want a formula to tell me if the entrance time is between 22:00 and 05:00.
If the answer to the above is yes - I want a "yes" as a outcome.
It is excel for Hebrew.