supersam92
New Member
- Joined
- May 23, 2020
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Hello, I need help please ?
I want to divide 24 hours into 4 categories:
00:00-09:14=1
09:15-11:59=2
12:00-17:14=3
17:15-23:59=4
Is there any way that I can turn a column of time into value 1/2/3/4?
E.g. 15:22 -> 3, 18:46 -> 4........
Thank you!
I want to divide 24 hours into 4 categories:
00:00-09:14=1
09:15-11:59=2
12:00-17:14=3
17:15-23:59=4
Is there any way that I can turn a column of time into value 1/2/3/4?
E.g. 15:22 -> 3, 18:46 -> 4........
Thank you!