How to use HOUR, MINUTE, SECOND and TIME in Excel with Example Download

If you have date time value in excel and want to get separate value of them - HOUR, MINUTE and SECOND function get you cover. And if you have separate value of HOUR, MINUTE and SECOND, then you want to group together then TIME formula is used.

HOUR formula in Excel

HOUR returns value of hour from date-time as number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
FORMULA:

=HOUR(serial_number)

◾ Serial_number: Required. Basically is time or date with time.

MINUTE formula in Excel

MINUTE returns minute from date-time or time as integer from 0 to 59.
FORMULA:

=MINUTE(serial_number)

◾ Serial_number: Required. Basically is time or date with time.

SECOND formula in Excel

SECOND returns value as second from date-time or time value as integer which range from 0 to 59.
FORMULA:

=SECOND(serial_number)

◾ Serial_number: Required. Basically is time or date with time.

TIME formula in Excel

TIME is used to put together of hour, minute and second to become time format.
FORMULA:

=TIME(hour,minute,second)

◾ hour Required. The value of hour.
◾ minute Required. The value of minute.
◾ second Required. The value of second.

Watch How to use HOUR, MINUTE, SECOND and TIME in Excel speak Khmer

ads

How to use HOUR, MINUTE, SECOND and TIME in Excel with Example Download