Hour From A Time In Excel

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.

Share The Knowledge

Random Posts

Leave a Reply