Build a time from hour, minute, second
Turn 14, 30 and 15 into a real time: 2:30:15 PM.
What you'll make

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | A8 | The hour, 0 to 23. | 14 |
| 2 | B8 | The minutes. | 30 |
| 3 | C8 | The seconds. | 15 |
| 4 | TIME( … ) | Puts them together as a real time. | 2:30:15 PM |
Hours use 24-hour numbering, so 14 is 2 PM and 0 is midnight.
=TIME(A8,B8,C8)How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own times. Paste the hour, minute and second into the green columns of the Template tab. The times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
An hour of 24 or more starts again from midnight, so 25 gives 1:00 AM. Check odd-looking times.
Microsoft's help: TIME function
OTHER ROUTES YOU MIGHT LIKE

Convert time text to a real clock time
14:30:15 as text → 2:30:15 PM
Get the template →
Keep the clock portion of a timestamp
November 4, 2026 2:30:15 PM → 2:30:15 PM
Get the template →
Extract the hour in 24-hour numbering
2:30:15 PM → 14
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →