Excel SECOND() Function

Excel SECOND() Function

The SECOND() function in excel converts a serial number to SECOND (0 - 59).

Syntax

SECOND (SERIAL_NUMBER)

Parameter

SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract seconds.

Category

Date & Time

Return

This function returns the SECOND from 0 to 59.

Example 1

Objective: Identify today's weekday number basis different return_type value

Col A	Result	Formula
11/12/2019 22:31	42	=SECOND(A15)
10:15 AM	0	=SECOND(A16)
10:20 PM	0	=SECOND(A17)

Example 2

Objective: Extract SECOND from below given dummy entries

Dummy Entries	Result	Formula
1-Jan-16 5:37:39 PM	39	=SECOND(A15)
0.46347	24	= SECOND(A16)
23-Feb-18	0	= SECOND(A17)

Example 3

Objective: Return current SECOND value

Result	Formula
54	=SECOND(NOW())

Related Topics

Shortcut Keys in Excel

Shortcut Keys in Excel Shortcut keys in Excel are used to simplify the work and save time by pressing a few keys. These keys are used for navigating and working with Excel spreadsheets quickly and easily. Basic Selection:...

9 minutes read.

Excel IFERROR() Function

The IFERROR() function in excel returns the specified value if initially supplied the argument or formula returns an error, otherwise returns the result of the formula supplied in the first argument. When...

2 minutes read.

Excel WORKDAY.INTL() Function

Excel WORKDAY.INTL() Function The WORKDAY.INTL() function in excel returns a date before or after a specified number of workdays with custom weekend parameter. Syntax WORKDAY.INTL (START_DAY, DAYS,[WEEKEND],[HOLIDAYS]) Parameter START_DAY (required)- This parameter represents the initial date...

2 minutes read.

Dependent Drop-down List in Excel

Excel forms are used to fetch data from the end user. When we have to give choices, we often use the drop-down feature of Excel. In this tutorial, we won’t...

7 minutes read.

Excel Themes

Microsoft Excel contains various features to enhance the appearance of the worksheet like text color, font size and general outlook of the objects. The users are provided with multiple theme...

3 minutes read.

How to remove duplicate values from excel?

Remove duplicate values from excel Duplicate values occur when the same date or set of values is repeated in your Excel sheet. While working with Excel sheets many a time, the...

5 minutes read.

Excel VALUE() Function

The VALUE() function in excel converts the specific text representing a number (i.e., a number, date, or time format) into a numerical value. Syntax VALUE(Text) Parameter Text(required)- This parameter represents the string that you want...

1 minute read.

Basics of Excel

Different ways to open an excel file There are various ways to open an excel file, some of them are listed below - From Start Menu:Go to the start menu and search for Ms-Excel...

5 minutes read.

Excel EDATE() Function

Excel EDATE() Function The EDATE() function in excel returns the serial number of the date that is the indicated number of months before or after the start date. Syntax EDATE(Start_Date, Month) Parameter Start_Date(required)- This parameter represents...

1 minute read.

Excel WEEKDAY() Function

The WEEKDAY () function in excel returns number from 1 (Sunday) to 7 (Saturday) identifying the day of the week based on its date. This function Default return is - Sunday would be...

1 minute read.

What do you understand by Combination Chart in Microsoft Excel?

In Microsoft Excel, an individual has the Combo Chart option available, which can be effectively clubbed into two charts types, which are Column Clusters Chart, Line Chart to get the...

7 minutes read.

Frequency Distribution in Excel

The term Frequency Distribution in Microsoft Excel is mainly used to explain how the data will be spread out. And it could be achieved with the help of the Histogram,...

7 minutes read.

Excel OFFSET () Function

Excel OFFSET () Function The OFFSET() function in excel returns range of cells that is a specified number of rows and columns from an initial specified range. Syntax OFFSET (reference, rows, cols, [height], [width]) Parameter reference(required)-...

2 minutes read.

Insert Row in Excel

It was known that we have various multiple ways that are extremely helpful in inserting a particular row in the Microsoft Excel. And we have lots of shortcut options available...

6 minutes read.

Paste Options in Excel

Excel spreadsheet is a combination of numeric values, alphabets which is used for calculation purposes. While performing the calculations, there is a need to repeat the data for further process....

6 minutes read.

Solver in Excel

What is Solver? Microsoft Excel facilitates an add-in programming tool known as Solver that uses operational research techniques to find the optimal solutions for objective problems. This tool operates with a group of...

5 minutes read.

Excel INDEX () Function

Excel INDEX () Function The INDEX() function in excel returns a value from a list of tables based on the intersection of a row and a column position. This function is used with the...

2 minutes read.

Excel MOD() Function

Excel MOD() Function The MOD() function in excel returns the remainder after a number is divided by a divisor Syntax MOD(number, divisor) Parameter Number(required)- This parameter represents the number which you want to divide. Divisor(required)- This parameter represents...

1 minute read.

How to Delete Row in Microsoft Excel?

Individuals can quickly delete the respective row from the particular Microsoft Excel whenever they want, according to their needs and requirements. In this tutorial, we will discuss the following things in...

7 minutes read.

Excel SUBSTITUTE() Function

The SUBSTITUTE() function in excel substitutes/replaces the old text with the new text in a string. SUBSTITUTE function is used to clean data. This function is case-sensitive. Syntax SUBSTITUTE(Text, Old_Text, New_Text, [instance_number]) Parameter Text (required)- This...

2 minutes read.