Tarih ve Saat

Excel HOUR İşlevi

Returns the hour of a time value as a number from 0 to 23.

Söz dizimi

HOUR(serial_number)

Bağımsız değişkenler

serial_numberzorunlu

The time that contains the hour you want to find.

HOUR fonksiyonunun ne işe yaradığı

The HOUR function extracts the hour component from a given time value. The result is an integer ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

=HOUR("15:30")→15

Extracts the hour from the time 3:30 PM.

Select a cell

Click on the cell where you want to display the result.

Enter the formula

Type =HOUR(A1) where A1 contains the time value.

What does the function return if the serial number is a date?

If the date does not include a time component, it returns 0.