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

Capture

Enter the Hour (number) formula to get the hour number.

Capture




As you could see 16 is returned corresponding to 4 PM

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply