Yes. Excel can show a date and a time together in one cell: if A2 contains a date and B2 contains a time, enter =A2+B2 in C2; with November 2, 2026 in A2 and 2:30 PM in B2, the result is the combined value November 2, 2026 at 2:30 PM. Apply a date-and-time number format to C2 to display both parts clearly.
Enter a date and time directly in one cell
For a single timestamp, you can type the date, a space, and the time into the same cell, such as 11/2/2026 2:30 PM. Excel will usually recognize that entry as one date-time value, though the exact date order it recognizes depends on your computer’s regional settings. In a day-month-year locale, for example, a numeric date may be interpreted differently from the same entry in a month-day-year locale. If the date matters, use an unambiguous format that matches your regional settings or build it from separate date components.
If Excel displays only the date or only the time after you enter both, the value may still contain both. The cell’s number format controls what is visible. Widening a column can help if the full display is clipped, but it does not change the underlying value.
How Excel stores dates and times
Excel represents a date-time as a number. The whole-number portion represents the date, and the fraction represents the time within that day. For example, noon is one-half of a day, or 0.5; 6:00 AM is one-quarter of a day, or 0.25. A combined timestamp is therefore a date serial plus a fraction of a day.
This design is why addition works for combining a date and a time. It also lets Excel sort date-times chronologically and use them in calculations. The displayed text is just a formatted view of the numeric value, not necessarily the literal contents stored in the cell.
Most Windows workbooks use Excel’s 1900 date system. Excel also supports a 1904 date system, which may appear in older or transferred workbooks. The same calendar date has a serial number 1,462 days apart between those systems. Avoid changing a workbook’s date system casually: values that are already stored as dates may shift when the setting changes.
Combine separate date and time cells
Keeping dates and times in separate columns can make data entry, validation, and reporting easier. To create a combined value, place the date in A2 and the time in B2, then use =A2+B2 in C2. If A2 is November 2, 2026 and B2 is 2:30 PM, C2 represents November 2, 2026 at 2:30 PM. Format C2 to show the result as one timestamp.
You can also construct a timestamp from separate year, month, day, hour, and minute fields. With the year in A2, month number in B2, day in C2, hour in D2, and minute in E2, enter =DATE(A2,B2,C2)+TIME(D2,E2,0). If those cells contain 2026, 11, 2, 14, and 30, respectively, the result is November 2, 2026 at 2:30 PM. The DATE and TIME functions also normalize values that exceed a component’s usual range, although it is usually clearer to correct unexpected input at its source.
For a whole column, enter the formula in the first row and fill it down. On Windows, drag the fill handle at the cell’s lower-right corner or select the range and press Ctrl+D. On Mac, the fill handle works as well; the keyboard shortcut for Fill Down is Control+D in Excel. Excel for the web also supports filling a formula down with the fill handle.
Choose a format that shows both parts
To format a selected cell in Excel for Microsoft 365 on Windows, press Ctrl+1 to open Format Cells, choose the Number tab, and select Custom. In the Type box, enter a format such as m/d/yyyy h:mm AM/PM, then select OK. The display will show a date followed by a 12-hour time and AM or PM. On Mac, Command+1 opens Format Cells; the same number-format codes are generally available. In Excel for the web, use the Home tab’s Number Format controls; options for defining custom formats can differ from desktop Excel.
Pick a format that suits the audience and the precision the data needs. Common examples include:
m/d/yyyy h:mm AM/PMfor a compact date and 12-hour time, such as 11/2/2026 2:30 PM.yyyy-mm-dd hh:mmfor a year-first, 24-hour display, such as 2026-11-02 14:30.mmm d, yyyy h:mm AM/PMfor a more readable display, such as Nov 2, 2026 2:30 PM.m/d/yyyy h:mm:ss AM/PMwhen seconds are relevant.
In Excel’s custom number formats, the meaning of a letter can depend on its position. In a date-time format, m near the date represents a month, while m near hours or seconds represents minutes. If a format shows a month where you expected minutes, check the placement of the code. Choosing a built-in date or time format first and then adjusting it can be easier than composing a format from scratch.
Keep the result usable for calculations
A number format changes how a value looks; it does not turn the value into text. A combined date-time made by adding a date and time remains a number that can be sorted, filtered, compared, or used in arithmetic. By contrast, the TEXT function returns formatted text, which can be useful for a label or report heading but is usually a poor choice for a column you still need to calculate with.
With the date in A2 and time in B2, =TEXT(A2+B2,"m/d/yyyy h:mm AM/PM") returns text such as “11/2/2026 2:30 PM.” Use this when a text string is specifically wanted, such as when joining a timestamp into a sentence. For a working data column, use the numeric result =A2+B2 and apply the custom number format instead.
For reliable sorting and calculations, keep one real date-time value per cell and avoid mixing timestamps with text labels in the same column. If a cell is left-aligned unexpectedly, or changing its format has no effect, Excel may have stored the entry as text. Re-entering the value, using a conversion step, or importing the data with appropriate regional settings may be necessary.
Calculate with combined timestamps
Excel can subtract one date-time from another because both are numeric values. If a start timestamp is in A2 and an end timestamp is in B2, use =B2-A2 to find the elapsed time. For example, a start of November 2, 2026 at 9:15 AM and an end of November 2, 2026 at 5:45 PM produce 8 hours and 30 minutes. Format the result as [h]:mm to show total elapsed hours. The square brackets matter: a plain hour format can wrap back to zero after 24 hours.
Adding a whole number to a date-time adds that many days. To add 90 minutes, add 90 divided by 1,440, since a day contains 1,440 minutes; alternatively, add the equivalent time using a TIME function. If a calculation crosses midnight, the date portion advances naturally. If the result looks like a clock time instead of a duration, change the result’s number format rather than replacing the formula.
Excel date-times do not automatically include a time zone or daylight-saving-time rule. A timestamp entered as 2:30 PM is simply a calendar date and time value; Excel does not infer whether it means a particular time zone or convert it when daylight-saving rules change. For schedules involving different locations, store the zone or offset separately and define a consistent conversion process.
Common problems and practical checks
- Only the date appears: Apply a format that includes hours and minutes. The time may already be present in the value.
- Only the time appears: Select a format that also includes a date. A time-only format can hide the date portion.
- The formula shows a decimal: The calculation may be correct, but the cell is formatted as General or Number. Apply a date-time format.
- The formula does not calculate: Check that the source cells contain numeric date and time values, not text that merely looks like a date or time.
- The result shows hash marks: Widen the column first. A negative date-time result can also be un displayable under the workbook’s date system; check the order of the start and end values.
- The date is wrong after importing: Regional date order may have caused Excel to interpret day and month in reverse. Review the source format and import settings.
A useful check is to select the cell and look at the formula bar. Changing the display format should alter how the date-time appears in the grid, while the value remains available for calculations. If the formula bar shows a text string and number formatting has no effect, investigate whether the value was imported or entered as text.
Frequently Asked Questions
Can Excel show a date and time in the same cell?
Yes. Enter both in one cell or combine a date value and a time value, then apply a number format containing both date and time codes.
How do I combine a date in one cell and a time in another?
If the date is in A2 and time is in B2, use =A2+B2 in another cell. Format the result as a date and time.
Why does Excel show a number instead of a date?
Dates and times are stored as numbers. Apply a date-time format to display the number as a calendar date and clock time.
How do I stop a duration from resetting after 24 hours?
Format the elapsed-time result with [h]:mm. The brackets display total hours rather than wrapping at one day.
Does Excel convert a timestamp between time zones?
No. A normal Excel date-time value has no time-zone information. Keep zone or offset data separately if your workflow needs conversions.
Related
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
- Remove Duplicates in Power Query: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Hyperlink in Excel SharePointTo hyperlink in an Excel workbook stored on SharePoint, open the workbook, select a cell, press Ctrl+K in…
- Make a Flowchart in Word: Shapes, Connectors, and TipsTo make a flowchart in Microsoft Word for Microsoft 365 on Windows, choose Insert > Shapes, select flowchart…
- Excel: How to Hide Columns With No Data AutomaticallyTo hide columns that contain no data in Excel for Microsoft 365 on Windows, identify the blank columns,…
- Unable to Add a Shared Mailbox in Outlook? FixesIf you cannot add a shared mailbox in Outlook, first confirm that your work or school account has…
- Freeze One Row and One Column in Excel at the Same TimeTo freeze the top row and first column together in Excel for Microsoft 365 on Windows, select cell…
- Google Sheets Inventory Spreadsheet: Setup and TipsYes. Google Sheets can serve as an inventory spreadsheet for a small shop, office, classroom, or household: list…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.