mickeystanford_alumni
Board Regular
- Joined
- May 11, 2022
- Messages
- 129
- Office Version
- 2021
- Platform
- Windows
- MacOS
Hello everyone, hope you are doing well.
I am trying to make an IF formula linking it to the exact time of the day.
So, if time right now is 11:00 (=TIME), I want excel to say:
A4=IF(A1<15:00, "A2","A3"), where A2 and A3 is two different values.
The only issue I face here is that the =TIME is tricky to make it higher or lower compared to 15:00...
Any suggestions or ideas?
Thank you
I am trying to make an IF formula linking it to the exact time of the day.
So, if time right now is 11:00 (=TIME), I want excel to say:
A4=IF(A1<15:00, "A2","A3"), where A2 and A3 is two different values.
The only issue I face here is that the =TIME is tricky to make it higher or lower compared to 15:00...
Any suggestions or ideas?
Thank you