Build a time from hour, minute, second

Turn 14, 30 and 15 into a real time: 2:30:15 PM.

What you'll make

In Excel: 14 + 30 + 15 becomes 2:30:15 PM.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesFor row 8
1A8The hour, 0 to 23.14
2B8The minutes.30
3C8The seconds.15
4TIME( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own times. Paste the hour, minute and second into the green columns of the Template tab. The times fill in by themselves.
  3. 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