Read a yyyymmdd hhmmss timestamp
Turn the code 20261104 143015 into a real date and time: November 4, 2026 2:30:15 PM.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATE( … ) | Reads the year, month and day as a real date. | November 4, 2026 |
| 2 | TIME( … ) | Adds the hour, minutes and seconds after the space. | November 4, 2026 2:30:15 PM |
LEFT, MID and RIGHT take digits by position. The year starts at 1, the month at 5, the hour at 10.
=DATE(LEFT(A8,4),MID(A8,5,2),MID(A8,7,2))+TIME(MID(A8,10,2),MID(A8,12,2),RIGHT(A8,2))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 codes. Paste codes like 20261104 143015 into the green column 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
Check each code has 8 digits, a space, then 6 digits. An impossible part, like day 31 in November, rolls into the next day without a warning.
Microsoft's help: TIME function
OTHER ROUTES YOU MIGHT LIKE

Read a timestamp split by a separator
4-Nov-2026 | 14:30:15 → November 4, 2026 2:30:15 PM
Get the template →
Read Unix seconds as a UTC timestamp
Unix seconds 1793802615 → November 4, 2026 2:30:15 PM
Get the template →
Read Unix milliseconds as a timestamp
Unix milliseconds 1793802615000 → November 4, 2026 2:30:15 PM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →