Excel Time Shortcut: How to Insert the Current Time

In Excel for Microsoft 365 on Windows, select a cell and press Ctrl+Shift+; (semicolon) to enter the current time as a fixed value. Use Ctrl+; to enter today’s date; to put both in one cell, enter the date, press Space, then enter the time.

The shortcut and what it inserts

The time shortcut records the time shown by your computer when you press it. It does not create a running clock: after the value is entered, it stays unchanged unless you replace or edit it. This makes the shortcut useful for a timestamp, such as noting when a task was completed, a call was made, or a row was updated.

Use the shortcut while a worksheet cell is selected and you are not actively editing its contents. The value goes into that cell. If you are typing inside a cell or the formula bar, first finish or cancel that edit, then select the destination cell.

Current time: Ctrl+Shift+; (semicolon).
Current date: Ctrl+; (semicolon).
Date and time in one cell: Ctrl+;, press Space, then Ctrl+Shift+;.

The semicolon is the key named in the shortcut. On many keyboards, typing a semicolon does not require Shift, while a colon does; follow the shortcut as written rather than substituting a colon. If your keyboard layout or laptop requires a different key combination to produce the semicolon key, check the layout-specific mapping.

How to enter a date and time together

To create one combined timestamp, select a blank cell, press Ctrl+;, press Space, and then press Ctrl+Shift+;. Excel enters a date, a separating space, and a time. For example, the cell could show 11/2/2026 9:15 AM if the date and time at entry were November 2, 2026, at 9:15 in the morning and the cell’s format uses that display style. Your actual result depends on when you press the keys and on your regional date and time settings.

To enter the date and time in separate cells instead, use Ctrl+; in one cell and Ctrl+Shift+; in another. This can make filtering or calculations easier. For instance, a date-only column can be grouped by day, while a separate time column can be sorted or compared without first extracting the time from a combined value.

Excel stores a date and time together as a number: the whole-number part represents a date, and the fractional part represents a portion of a day. A time-only entry is therefore a fraction of a day. For example, noon corresponds to half a day. The shortcut creates a value that Excel can calculate with, not merely a string of characters that looks like a time.

What Excel does with the entered value

The displayed appearance is controlled by the cell’s number format. Excel may show the time in a 12-hour style such as 9:15 AM or a 24-hour style such as 09:15, depending on the format and regional settings. The underlying time value remains suitable for calculations either way.

If you see an unexpected display, select the cell and inspect Home > Number. Choose a suitable time format, or open the Format Cells dialog with Ctrl+1 and select a time or custom format. Changing the number format changes how the value looks; it does not change the time that was recorded. A format such as hh:mm:ss displays seconds if they are part of the stored value, while a format such as h:mm AM/PM shows a 12-hour clock.

In a date-and-time cell, a date-only format can hide the time, and a time-only format can hide the date. The information may still be present in the cell. Check the formula bar or choose a format that displays both parts before assuming the shortcut omitted one of them.

Static timestamp or a live clock?

The shortcut is usually the right choice when you want a permanent record of when you entered something. A worksheet formula is different: it can update when Excel recalculates. For a live date-and-time value, with cell A1 available for the result, enter =NOW(). If the formula is evaluated on November 2, 2026, at 9:15 AM, it returns that date and time; its displayed appearance depends on A1’s number format. NOW is a volatile function, so its result can change as the workbook recalculates. It is not a dependable way to preserve the moment a row was first created.

A related function, TODAY, returns the current date without a time and also updates with recalculation. Neither function is a substitute for a fixed timestamp when you need an audit trail. If you need an automatically captured timestamp triggered by a particular edit, that requires a different workflow, such as an approved automation or a carefully designed macro; a formula alone does not permanently stamp the first entry.

For a fixed entry, use the keyboard shortcut and avoid replacing it with NOW or TODAY. For a display that should always reflect the current date or time, use a formula and understand that recalculation can change it. This distinction matters in timesheets, logs, and reports: a changing value can make yesterday’s record appear to have a newer timestamp.

Windows, Mac, and Excel for the web

The main shortcut in this article is for Excel on Windows. In Excel for Mac, Microsoft documents Control+; for the current date and Command+; for the current time. To combine them, enter the date, type a space, and then enter the time using the Mac time shortcut. Keyboard layouts and macOS settings can affect which physical key corresponds to a symbol, so use the semicolon key named by the shortcut.

Excel for the web runs in a browser, where keyboard combinations can sometimes be affected by browser or operating-system shortcuts. If the Windows combination does not enter a time in your session, try the date and time entry from the desktop app or use a suitable value entered into the cell. Avoid assuming that a shortcut listed for Windows desktop Excel behaves identically in every browser.

On a laptop, a separate numeric keypad is not required. The main issue is usually the keyboard layout or whether the cell is in edit mode, not the absence of a number pad. If a shortcut seems to do nothing, click a worksheet cell, make sure Excel has focus, and try again.

Common problems and quick checks

When the result is not what you expected, check the entry and display separately. A correct stored value can appear surprising because of the cell format, while a key combination can fail because focus is elsewhere.

The cell shows a decimal number: The value may be correct but formatted as General or Number. Apply a time format through Home > Number or Ctrl+1.
The time appears without the date: That is normal for the time-only shortcut. Use the date shortcut as well if you need a combined timestamp.
The time looks different from your clock: Check the computer’s clock, time zone, and regional settings, then check Excel’s display format. Excel uses the system’s current date and time when entering the value.
The value changes later: Check whether the cell contains a formula such as NOW rather than a fixed shortcut entry.
The shortcut is typed as text or does nothing: Confirm that the worksheet cell is selected, Excel has focus, and you are not still editing a cell or using a keyboard layout with a different semicolon mapping.

Also check whether the cell is formatted as Text. Text formatting can affect how entries are interpreted. If a value does not behave like a time, change the format and re-enter the shortcut in a suitable cell rather than relying only on how the characters look.

When this shortcut is useful—and when it is not

A fixed time is convenient for manual records: tracking when you start a task, noting a delivery time, adding a timestamp to a meeting log, or marking when a value was checked. Because it does not update on recalculation, it is more appropriate than NOW for a record intended to remain as entered.

However, the shortcut captures the time you press the keys, not necessarily the time an event happened. If you enter a backlog of records later, the timestamp will reflect the entry time rather than the original event time. It also does not identify who entered the value or prevent later edits. For regulated or collaborative records, use a process that provides the required controls and traceability instead of treating a manually entered timestamp as proof of an event.

For elapsed time, subtract one date-time value from another and format the result appropriately. A normal clock display can wrap after 24 hours; when a duration may exceed a day, a custom format such as [h]:mm is commonly used to show total hours. That is a formatting issue, not a different time-entry shortcut.

Frequently Asked Questions

Does Ctrl+Shift+; update automatically?
No. It enters a fixed time value at the moment you press the shortcut. It will not keep ticking like a clock.

What is the Excel shortcut for today’s date?
In Excel for Windows, press Ctrl+;. For Excel for Mac, use Control+; according to Microsoft’s documented shortcut.

How do I insert the date and time in one Excel cell?
Press Ctrl+;, press Space, and then press Ctrl+Shift+;. Excel enters the date and time as one combined value.

Why does Excel show a number instead of a time?
Excel stores times as numeric fractions of a day. Apply a time number format to show the value as a clock time.

Can I make Excel enter a timestamp automatically when I edit a row?
Not with the time shortcut alone. It only enters a value when you invoke it. Automatic stamping needs a suitable automation or macro, and should be designed so later edits do not silently rewrite the original timestamp.

What is the Mac shortcut for the current time?
In Excel for Mac, use Command+; to enter the current time. The current-date shortcut is Control+;.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.