Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TIME
TIME constructs a fractional time value from individual hour (0–23), minute (0–59), and second (0–59) components, returning a decimal between 0 and 0.999… that represents a fraction of a 24-hour day. Use it to combine separate time components, add a fixed duration to a time, or compare times stored in different columns.
Excel
=TIME(9,30,0)Google Sheets
=TIME(9,30,0)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Hour | Minute | Second | Time |
| 9 | 30 | 0 | 9:30 AM |
| 14 | 45 | 30 | 2:45 PM |
| 0 | 0 | 0 | 12:00 AM |
=TIME(9,30,0)→0.3958333333
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Provide hour, minute, and second as numbers or cell references: =TIME(A2,B2,C2).
- 2The result is a decimal fraction; format the cell as Time (h:mm AM/PM) to display it meaningfully.
- 3Add a TIME value to a date serial (from NOW() or DATE()) to combine date and time in one cell.
Need a version for your data?
Try: “Combine separate hour, minute, and second columns into a single time value”