What is TIME called in Spanish?

In Spanish Excel it is NSHORA. The formula =IF(B2<=TIME(9,0,0),"Yes","No") is written =SI(B2<=NSHORA(9;0;0);"Sí";"No") (or with commas in Mexico).

Why does TIME 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 TIME function

Q: Why does TIME 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.

Q: What is the most common TIME mistake?

In Spanish Excel it is NSHORA. Use it to compare: =IF(B2<=TIME(9,0,0),"On time","Late").

Builds a time value from hours, minutes and seconds. In Spanish Excel it is called NSHORA.

Syntax

English Excel

=TIME(hour, minute, second)

Spanish Excel (Mexico)

=NSHORA(hora, minuto, segundo)

Spanish Excel (Spain, Latin America)

=NSHORA(hora; minuto; segundo)

Argument	What it is
hour	The hour, from 0 to 23.
minute	The minutes.
second	The seconds.

Example

HOUR and MINUTE pull the hour and minutes out of a time or date-time. TIME(hour, minute, second) builds a time to compare with: TIME(9, 0, 0) is 9:00.

=IF(B2<=TIME(9,0,0),"Yes","No")

Common mistake

In Spanish Excel it is NSHORA. Use it to compare: =IF(B2<=TIME(9,0,0),"On time","Late").

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 TIME

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

HOUR, MINUTE and TIME

HOUR and MINUTE pull the hour and minutes out of a time or date-time. TIME(hour, minute, second) builds a time to compare with: TIME(9, 0, 0) is 9:00.

Example=HOUR(B2)HORA = HOUR MINUTO = MINUTE NSHORA = TIME SI = IF

Step 1/3

In C2, extract the arrival hour.

	A	B	C	D	E
1	Employee	Arrival	Hour	Minutes	On time?
2	Carmen	08:52
3	Jorge	09:17
4	Lucía	08:59
5	Andrés	09:04
6	Paola	08:41
7

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

Frequently asked questions

What is TIME called in Spanish?: In Spanish Excel it is NSHORA. The formula =IF(B2<=TIME(9,0,0),"Yes","No") is written =SI(B2<=NSHORA(9;0;0);"Sí";"No") (or with commas in Mexico).
Why does TIME 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 TIME mistake?: In Spanish Excel it is NSHORA. Use it to compare: =IF(B2<=TIME(9,0,0),"On time","Late").