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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATEVALUE(A8) | Turns the date text into a real date. | November 4, 2026 |
| 2 | TIMEVALUE(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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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



