Write a full appointment date and time

Turn 11/4/2026 2:30 PM into the text November 4, 2026 at 2:30 PM for a letter.

What you'll make

In Excel: 11/4/2026 2:30 PM becomes November 4, 2026 at 2:30 PM.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The real appointment date and time.11/4/2026 2:30 PM
2"mmmm d, yyyyWrites the month name, day and year."November 4, 2026"
3""at""Adds the word at."November 4, 2026 at"
4h:mm AM/PM"Adds the hour, minutes and AM or PM."… 2026 at 2:30 PM"
5TEXT( … )Writes the date and time in that pattern as text."… 2026 at 2:30 PM"

Parts 2 to 4 are one pattern. The doubled quotes keep at as a plain word.

=TEXT(A8,"mmmm d, yyyy ""at"" h:mm AM/PM")

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 real dates and times into the green column of the Template tab. The letter text fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Seconds and time zone are left off. Check the times are in the reader's own time zone.

Microsoft's help: TEXT function