What is NOW called in Spanish?

In Spanish Excel it is AHORA. The formula =INT((NOW()-B2)*24) is written =ENTERO((AHORA()-B2)*24) (or with commas in Mexico).

Why does NOW use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel NOW function

Returns the current date and time. It takes no arguments. In Spanish Excel it is called AHORA.

Syntax

English Excel

=NOW()

Spanish Excel (Mexico)

=AHORA()

Spanish Excel (Spain, Latin America)

=AHORA()

Example

NOW() returns the current date and time. In Excel a day is 1, so subtracting dates gives days: multiply by 24 to get hours. It recalculates whenever the sheet changes.

=INT((NOW()-B2)*24)

Common mistake

It recalculates on every change to the workbook. For the date alone use TODAY; to stamp a fixed time press Ctrl+Shift+; in a cell.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice NOW

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/202

My Excel is inExcel functions in English and Spanish

Elapsed hours with NOW

NOW() returns the current date and time. In Excel a day is 1, so subtracting dates gives days: multiply by 24 to get hours. It recalculates whenever the sheet changes.

Example=INT((NOW()-B2)*24)AHORA = NOW

In C2, calculate how many full hours the ticket has been open.

	A	B	C
1	Ticket	Opened	Hours open
2	T-301	01/05/2026, 09:30
3	T-302	02/14/2026, 16:15
4	T-303	03/02/2026, 08:00
5	T-304	03/20/2026, 13:45
6

Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.

Frequently asked questions

What is NOW called in Spanish?: In Spanish Excel it is AHORA. The formula =INT((NOW()-B2)*24) is written =ENTERO((AHORA()-B2)*24) (or with commas in Mexico).
Why does NOW use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common NOW mistake?: It recalculates on every change to the workbook. For the date alone use TODAY; to stamp a fixed time press Ctrl+Shift+; in a cell.