Formula guide · Excel and Google Sheets · Updated May 13, 2026
Combine Date and Time in Excel or Google Sheets
Combine separate date and time columns into one timestamp value.
Quick Answer
Add the date value and time value together, then format the result as a date-time.
Copyable Formula
=A2+B2Syntax
=date_cell+time_cellExcel and Google Sheets
Worked Example
| A | B | C |
|---|---|---|
| Date | Time | Timestamp |
| 2026-05-13 | 14:30 | 2026-05-13 14:30 |
Result: Returns one timestamp that can be sorted and filtered.
Steps
- Confirm the date column contains real dates.
- Confirm the time column contains real time values.
- Add the two cells together.
- Format the result as date and time.
Common Mistakes
- Combining text dates and text times without converting them first.
- Formatting the result as time only and hiding the date.
- Using text concatenation when a real timestamp is needed.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.