mihir777
New member
- Joined
- May 28, 2016
- Messages
- 24
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2016
Hello,formula for multiple conditions but as my Excel is not having IFS formula i want some formula which i can replace with.=IFs(AND(E4>=MIN("00:01"),E4=MIN("8:00"),E4=MIN("12:01"),E4=MIN("15:01"),E4=MIN("19:31"),E4