Date FunctionsBeginner

HOUR, MINUTE, and SECOND Functions

Extract time components from time values.

Task:

Extract the hour, minute, and second from times in column A and display them in separate columns.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of HOUR, MINUTE, SECOND

0/3

The same formula in the other shapes it takes at work.

  1. HOUR, MINUTE, and SECOND Functions

    Extract time components from time values.

    CoreBeginner
  2. A time as a total number of minutes

    Hours × 60 plus minutes — the reverse of TIME.

    Beginner
  3. A time as decimal hours for billing

    1:30 is 1.5 hours, not 1.3.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

4 rows × 4 columns9 cells you fill in
ABCD
1TimeHourMinuteSecond
210:30:00
314:45:30
417:00:00

Functions used here

What this exercise teachesMay contain the answer

HOUR, MINUTE, and SECOND functions extract individual time components for analysis.