Formula Errors

How to Fix Excel NOW Formula for Checking Time After Noon

Amos Gikunda Oct 12, 2026 869 views

Question details

The user needs to correctly compare the current time with noon using the NOW() function, avoiding calculation errors caused by the date portion.

Fixing the Excel NOW Formula for Checking If Time Is After Noon

Product: Excel
Device & OS: not provided
Scenario: Comparing the current time to 12:00 PM (noon) to trigger specific conditional updates or cell text.
Observed behavior: Comparing NOW() directly to TIME(12,0,0) yields incorrect results because NOW() includes both date and time, making it mathematically greater than a pure time value.

Before you start

Understand that the NOW() function returns a serial number representing both today's date and the current time. To compare it against a specific time of day, you must extract only the time portion.

Solution 1Recommended

Use the HOUR Function to Extract and Compare Time

Extract the hour from the NOW() function to accurately compare the current time against noon (12:00).

Because the NOW() function includes the current date, direct comparisons with TIME(12,0,0) fail. Using the HOUR() function isolates the time element, allowing for a precise evaluation.

Select the target cell

Click on the cell where you want the conditional result to appear.

Enter the HOUR and IF formula

Type the formula: =IF(HOUR(NOW())>=12,IF(HOUR(G21)<=12,"Update","Ok"),IF(HOUR(G21)<12,"Ok","Update")) (adjust G21 to your reference cell).

Press Enter to apply

Hit the Enter key. The cell will now correctly evaluate whether the current time is before or after noon.

Use the HOUR Function to Extract and Compare Time

Dynamic Updates: The NOW() function is volatile and updates only when the worksheet is recalculated or modified.

WPS Spreadsheet Solution

Easily Manage Time and Date Formulas in WPS Spreadsheet

WPS Spreadsheet offers full compatibility with standard Excel time and date functions. You can seamlessly use NOW(), HOUR(), and TIME() formulas to build complex logical statements without worrying about syntax differences.

1. Open WPS Spreadsheet: Launch WPS Office and open your workbook in the Spreadsheet module.
2. Insert the Formula: Select a cell and input your nested IF and HOUR(NOW()) formula just like you would in Excel.
3. Evaluate and Adjust: Use the built-in Formula tab to calculate the sheet and verify the results.

Fully compatible with Microsoft Excel date and time functions.Lightweight, fast, and completely free to use.Built-in formula evaluation tools to help troubleshoot nested IF statements.

Frequently Asked Questions

Why does NOW() always appear greater than TIME(12,0,0)?

In spreadsheet software, dates are stored as whole numbers and times as fractional values. NOW() includes the date (e.g., 45000.5), while TIME(12,0,0) is only a fraction (0.5). Therefore, the full date and time is mathematically much larger than the time alone.

How can I extract just the time from the NOW() function without the HOUR function?

You can isolate the time portion by subtracting the integer of the date using this formula: =NOW()-INT(NOW()). This leaves only the decimal value representing the current time.

Does the NOW() formula update continuously in real-time?

No, the NOW() function is a volatile formula that only updates when the worksheet is recalculated, such as when you edit a cell or manually press F9.

Excel & Data Problems