Date Functions
Beginner

A time as a total number of minutes

Hours × 60 plus minutes — the reverse of TIME.

Task:

The phone system wants call lengths in whole minutes. In C2:C6 convert each duration in B into a total number of minutes.

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.

    Core
    Beginner
  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.

6 rows × 3 columns5 cells you fill in
ABC
1CallDurationMinutes
2K10:45
3K21:20
4K32:05
5K40:08
6K53:30
What this exercise teachesMay contain the answer

HOUR and MINUTE read the parts of a time, and arithmetic puts them back together in a different unit. MINUTE alone would say 20 for an 80-minute call — the hour has to be counted too.