TIME Function
Builds a time from hours, minutes and seconds.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A time (fraction of a day)
Want to practice TIME in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
TIME turns hours, minutes and seconds into a time Excel can calculate with.
Excel stores a time as a fraction of a day: 0.5 is noon, 0.75 is 6:00 PM. A date with a time is the date's whole number plus that fraction.
Syntax
=TIME(hour, minute, second) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| hour | Yes | 0–23. Larger numbers wrap around the clock (27 becomes 3:00 AM). |
| minute | Yes | Minutes. 90 becomes 1 hour 30 minutes. |
| second | Yes | Seconds. |
Examples
Example 1 — Shift start times
The rota stores hours, minutes and seconds in separate columns.
D2fx=TIME(A2,B2,C2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Hour | Minute | Second | Time |
| 2 | 9 | 30 | 0 | 9:30 AM |
| 3 | 14 | 15 | 0 | 2:15 PM |
| 4 | 17 | 45 | 30 | 5:45:30 PM |
=TIME(A2,B2,C2) Explain
Example 2 — Adding minutes to a time
Meeting end times from a start time and a length in minutes.
C2fx=A2+TIME(0,B2,0)
| A | B | C | |
|---|---|---|---|
| 1 | Starts | Minutes | Ends |
| 2 | 9:00 AM | 90 | 10:30 AM |
| 3 | 1:45 PM | 30 | 2:15 PM |
=A2+TIME(0,B2,0) Explain
Common mistakes
- TIME(25,0,0) shows 1:00 AM. TIME wraps past midnight. For durations longer than a day, add hours/24 instead, and format as [h]:mm.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.