Date Functions
Beginner
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.
Learning Objectives:
- Learn time extraction functions
- Understand time components
- Practice time analysis
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 | Time | Hour | Minute | Second |
| 2 | 10:30:00 | |||
| 3 | 14:45:30 | |||
| 4 | 17:00:00 |
What this exercise teaches (contains the answer)
HOUR, MINUTE, and SECOND functions extract individual time components for analysis.