Extracting Parts of a Time in Excel

In some situations, you need to be able to pick out a specific part of a time. Excel provides a simple set of functions to parse times out into their component parts. These functions are

  • 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

The figure demonstrates the use of these functions to parse the time in cell C3 into its component time parts.

image0.jpg

These functions are fairly straightforward.

The HOUR function returns a number between 0 and 23 corresponding to the hour of a given time. The following 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")