Let’s see how to get the hour from time in excel.
Hour () formula in excel returns a number from 0 (12 AM) to 23 (11 PM).
Suppose we want to know the hour number from the given time below
Enter the Hour (number) formula to get the hour number.
As you could see 16 is returned corresponding to 4 PM
Hope this helped.