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.
Example - 2:
The example below returns seconds for the time specified in cell B2.
Previous: Excel NOW ()function
Next:
Excel TIME() function
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework