Date FunctionsBeginner

TIME Function

Create time values from hour, minute, and second components.

Task:

Create time values in column D by combining hours, minutes, and seconds from columns A, B, and C.

Interactive Spreadsheet

Read about TIME

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 TIME

0/3

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

  1. TIME Function

    Create time values from hour, minute, and second components.

    CoreBeginner
  2. TIME with minute overflow: when does it finish?

    Minutes over 59 carry into the hour automatically.

    Intermediate
  3. TIME from a total number of minutes

    Put every minute in the minute argument and let TIME sort it out.

    Beginner

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 columns3 cells you fill in
ABCD
1HourMinuteSecondTime
210300
3144530
41700

Functions used here

What this exercise teachesMay contain the answer

The TIME function creates a time value from separate hour, minute, and second components.