In this post you will learn how to get hour, minute and seconds from a time in Excel.
Extracting parts of a time –
It’s often helpful to pick out a specific part of a time. Excel provides a simple set of func-
tions to parse time out into its component parts. These functions are as follows:
HOUR extracts the hour portion of a given time value.
MINUTE extracts the minute portion of a given time value.
SECOND extracts the second portion of a given time value.
Figure below demonstrates the use of these functions to parse the time in cell C3 into its
component parts.
These functions are fairly straightforward.
The HOUR function returns a number between 0 and 23 corresponding to the hour of a
given time. This formula returns 6.
=HOUR("6:15:27 AM")The MINUTE function returns a number between 0 and 59 corresponding to the minutes of
a given time. This formula returns 15.
=MINUTE("6:15:27 AM")The SECOND function returns a number between 0 and 59 corresponding to the seconds of a
given time. This formula returns 27.
=SECOND("6:15:27 AM")