Join date and clock text into a timestamp

Turn the text 4-Nov-2026 and 2:30:15 PM into one real date and time.

What you'll make

In Excel: 4-Nov-2026 + 2:30:15 PM becomes November 4, 2026 2:30:15 PM.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1DATEVALUE(A8)Turns the date text into a real date.November 4, 2026
2TIMEVALUE(B8)Turns the clock text into a time and adds it.… 2:30:15 PM

Read it left to right. A real date and time can be sorted and used in other formulas.

=DATEVALUE(A8)+TIMEVALUE(B8)

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 dates and times. Paste date text like 4-Nov-2026 and clock text like 6:45 PM into the green columns of the Template tab. The dates and times fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use month names like 4-Nov-2026. Numbers-only dates like 04/11/2026 can swap day and month.

Microsoft's help: TIMEVALUE function