Date Functions
Beginner
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.
Learning Objectives:
- Learn TIME function
- Understand time construction
- Practice time value creation
Hints
Solve without hints for +5 XP
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.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Hour | Minute | Second | Time |
| 2 | 10 | 30 | 0 | |
| 3 | 14 | 45 | 30 | |
| 4 | 17 | 0 | 0 |
What this exercise teaches (contains the answer)
The TIME function creates a time value from separate hour, minute, and second components.