Sorting Times

[jedilefty]

Afternoon!

I need help with sorting time stamps into groups based on which hour block it occurred. The time stamps are in military format, so the desired outcome can either stay in the same format or regular 12hr format [which ever is easier]. And the date itself will always be the same, just different time intervals. I have a sample table below.

Time Stamp	Hour Block
7/7/23 11:01	11
7/7/2023 11:05	11
7/7/23 10:42	10
7/7/23 11:02	11
7/7/23 15:11	15 or 3
7/7/23 10:52	10
7/7/23 15:12	15 or 3
7/7/23 17:10	17 or 5
7/7/23 18:14	18 or 6

 

[Joe4]

If your entries are valid date/time entries, you can simply use the HOUR function to pull the hour out.
For example, if cell A2 is "7/7/23 18:14" then this formula:

=HOUR(A2)

will return 18