Excel NOW Time: Current Time, Formulas, and Shortcuts

Formulas & functions · Updated November 18, 2026

To display the current date and time in Excel, enter =NOW() in a cell; to show only the time, format that cell as a time. If you need a time that stays fixed instead of updating when Excel recalculates, use the current-time keyboard shortcut, Ctrl+Shift+; on Windows.

What Excel NOW returns

NOW is a worksheet function that returns the current date and time according to the computer’s system clock. Excel stores dates and times as numbers: the whole-number portion represents a date, and the decimal portion represents the time within that day. For example, a time such as noon is represented by half of a day. The number you see depends on the cell’s number format, not on a different kind of value being stored.

If you enter the function in A1, the assumed layout is simply a blank A1 cell receiving the formula. The result is a date-and-time value, not a text label, so it can be formatted, compared, or used in calculations. The displayed result will vary with the date and time when Excel calculates it.

NOW does not take arguments. Do not add a date, a time zone, or parentheses containing a setting. It uses the local system time available to Excel; it does not independently check an internet time server or establish a time zone for the workbook. If the computer’s clock is wrong, the displayed result can be wrong too.

How to display only the current time

The simplest method is to enter NOW and change the cell’s number format. The underlying value still contains both date and time, but the date portion is hidden from view. This is useful for a live clock display, a report header, or a calculation that needs the current time while showing a compact result.

  1. Select the cell containing the function.
  2. Press Ctrl+1 to open Format Cells.
  3. On the Number tab, select Time and choose a time style, or select Custom and enter a format such as h:mm AM/PM or hh:mm:ss.
  4. Select OK. The cell displays the time in the selected style.

In Excel for Mac, Command+1 opens Format Cells. Excel for the web has a number-format control on the Home tab; select a time format there, or use the desktop app for the full custom-format dialog. A format like h:mm AM/PM displays a 12-hour clock with an AM or PM marker. A format like hh:mm:ss displays hours, minutes, and seconds using a 24-hour clock. The leading zero in hh is what makes a time such as 8:04 appear as 08:04.

Formatting changes appearance only. It does not remove the date from the stored value or make the result static. If you later use the cell in date-and-time arithmetic, Excel still has the full NOW result available.

Why NOW does not tick every second

A common expectation is that NOW behaves like a digital clock and changes once per second. In a worksheet, it generally does not. NOW is a volatile function, which means Excel recalculates it when the workbook recalculates. With the usual automatic calculation setting, that can happen after edits and other calculation events, but Excel does not promise a continuous one-second refresh.

To request a recalculation on Windows, press F9 to recalculate open workbooks, or Shift+F9 to recalculate the active worksheet. You can also check Formulas > Calculation Options > Automatic. If calculation is set to Manual, NOW may remain unchanged until you trigger a calculation. On a Mac, the recalculation keys can differ by keyboard and system settings; use the Formulas tab’s calculation controls if a function key does not work as expected.

Repeatedly forcing recalculation is not always a good solution. A large workbook can become slower, and formulas that depend on NOW may all update together. For an ordinary worksheet timestamp, use a fixed entry instead. For a display that must refresh like a live clock, a worksheet formula alone is usually not a dependable second-by-second timer.

NOW versus a fixed time stamp

A formula is appropriate when the value should mean now each time Excel recalculates. Examples include showing the report’s current date and time, calculating elapsed time from the present, or displaying when a dashboard was last refreshed. It is not appropriate if the value is intended to record when a person completed a task, because the value can change later.

For a fixed time in the selected cell, press Ctrl+Shift+; on Windows. Excel inserts the current time as a value, so it will not change when the workbook recalculates. The shortcut records the time at the moment of entry, based on the computer’s clock. To insert the current date, the Windows shortcut is Ctrl+;. To enter both date and time, use the date shortcut, enter a space, and then use the time shortcut.

On Mac, Excel’s date and time shortcuts can vary with the keyboard layout and macOS settings. If the time shortcut is inconvenient, type the time directly or use the desktop app’s available date/time entry method, then confirm the cell contains a value rather than a formula. In Excel for the web, keyboard shortcuts can also be affected by the browser, so check the app’s shortcut guidance if a key combination is intercepted.

Another way to freeze a NOW result is to copy the cell and paste its value back over the formula. This replaces the live function with the result currently displayed. Be deliberate: once the formula is replaced, it will no longer update. If the timestamp is important as a record, save the workbook and consider protecting or documenting the entry process so it is not accidentally changed.

Choosing the right time function

NOW, TODAY, and TIME sound related, but serve different purposes. NOW returns the current date and time. TODAY returns the current date without a time component, making it useful for date-based comparisons or a daily report date. TIME constructs a time from hour, minute, and second numbers; it does not read the computer clock. For instance, TIME can represent a scheduled start such as 9:30 AM, while NOW represents the present moment.

Use a time-only display format when you want to hide the date from NOW. Use TODAY when you genuinely need the date alone. Use a fixed time entry when you need a record of when something happened. These choices matter because formatting can make different values look alike: a cell showing 9:30 AM could contain a fixed time, a full date-and-time value with the date hidden, or a scheduled time constructed for a calculation.

Before building a formula around a time, decide whether it should move forward as the workbook recalculates. A deadline countdown or elapsed-time calculation may need a live current value. A sign-off field, check-in log, or completion record normally needs a value that stays put. This distinction prevents a frequently seen mistake: using NOW as a permanent timestamp and then discovering that old records show the latest recalculated time.

Formatting and calculation details

Excel’s time formats determine whether seconds, leading zeros, or AM/PM appear. A custom format can display hours and minutes, seconds, or a 24-hour clock. If a cell shows a large number instead of a readable time, the function may still be working; the cell is probably formatted as General or a numeric format. Apply a time format through Format Cells rather than changing the formula.

If a time appears as a row of number signs, the column may be too narrow to display the chosen format. Widen the column or choose a shorter format. If the displayed time seems one hour off, check the computer’s clock and regional time settings, and confirm whether the cell is showing a 12-hour or 24-hour value as intended. Excel does not automatically convert NOW into a selected time zone simply because a workbook is shared with someone elsewhere.

Because the date and time are numeric values, they can be used for arithmetic. For example, subtracting an earlier date-and-time value from a later one gives elapsed time as a fraction of a day. The result may need a duration format, especially when the duration can exceed 24 hours. A standard clock format can wrap around after a full day, which may make a long duration look misleading.

Common problems and practical fixes

  • The time is not changing: Check whether calculation is set to Manual, then recalculate with F9 or use the Formulas tab. Remember that recalculation does not create a continuous clock.
  • The cell shows a date as well as a time: Apply a time-only number format. The date remains part of the stored value.
  • The cell shows a number: Change the number format to Time or use a custom time format.
  • An old record changed: It probably used NOW as a formula. Replace it with a fixed timestamp value when the record is made.
  • The time is unexpected: Compare it with the computer’s system clock and check the workbook’s calculation mode and display format.

For shared workbooks, remember that recalculation and display can happen on different devices with different clock settings. A NOW result is useful for showing the time available to the current calculation, but it is not a tamper-proof audit log and does not prove when a user performed an action. For reliable process records, use an appropriate logging system rather than relying on a volatile worksheet formula alone.

Frequently Asked Questions

How do I get the current time in an Excel cell?

Enter NOW in a formula in the cell to return the current date and time, then apply a time-only number format if you do not want the date displayed. The value can update when Excel recalculates.

What is the Excel shortcut for the current time?

In Excel for Windows, Ctrl+Shift+; inserts the current time as a fixed value. It does not insert a live formula. On Mac or in a browser, the shortcut may differ depending on the keyboard and app environment.

Does Excel NOW update every second?

No. NOW updates when Excel recalculates the workbook or relevant worksheet; it is not a guaranteed continuously updating clock. Press F9 on Windows to request recalculation.

How do I show only the time from NOW?

Format the cell as Time, or choose a custom format such as h:mm AM/PM or hh:mm:ss. The date remains in the cell’s underlying value but is hidden by the format.

How do I keep the time from changing?

Use Ctrl+Shift+; on Windows to insert a fixed time, or copy a NOW result and paste it as a value. A fixed value will not update during recalculation, though it can still be edited manually.

What is the difference between NOW and TODAY?

NOW returns the current date and time; TODAY returns the current date without a time. Both are recalculated worksheet functions, so neither is a permanent timestamp by itself.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.