w3resource

Excel SECOND() function

SECOND() function

This function is used to return the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.

Version: Excel 2013

Syntax:

SECOND(serial_number)

Parameters:

Name Description Data Type Required/
Optional
Serial_number The time that contains the seconds you want to find. Times may be entered as text strings within quotation marks. strings Required

Remarks:

Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).

Example - 1:

The example below returns seconds for the time specified in cell B2.

second1

Example - 2:

The example below returns seconds for the time specified in cell B2.

second2

Previous: Excel NOW ()function
Next: Excel TIME() function



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://w3resource.com/excel/excel-second-function.php