Returns the second component of a time Show What is the SECOND Function?The SECOND Function[1] is categorized under Excel DATE/TIME functions. The function returns the second component of a time as a number between 0-59. For example, it will return 49 for 1:19:49 PM. Formula=SECOND(serial_number) The SECOND function uses only one argument: Serial_number (required argument) – The time that contains the second we want to find. The argument can be entered as:
How to use the SECOND Function in Excel?As a worksheet function, the SECOND function can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let’s consider an example: ExampleLet’s see how this function works using the following inputs: The results in Excel are shown in the screenshot below: In case we get an error, we need to remember that Excel stores dates and times as serial numbers. For example, the date January 1, 2000, 12:00 PM is equal to the serial number 32526.5 in Excel. To check that Excel correctly recognizes a date or time, we can temporarily format the date as a number. A few notes about the SECOND Function
Click here to download the sample Excel file Additional ResourcesThanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Article Sources
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less This article describes the formula syntax and usage of the SECOND function in Microsoft Excel. DescriptionReturns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59. SyntaxSECOND(serial_number) The SECOND function syntax has the following arguments:
RemarkTime 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). ExampleCopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Need more help?What is second formula?The Excel SECOND function returns the second component of a time as a number between 0-59. For example, with a time of 9:10:15 AM, second will return 15. You can use the SECOND function to extract the second into a cell, or feed the result into another formula, like the TIME function.
How do I use second in Excel?Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
...
Example.. What does SEC in Excel mean?The Excel SEC function returns the secant of an angle provided in radians. Get secant of an angle. The secant value. =SEC (number)
What is the time formula in Excel?Another simple technique to calculate the duration between two times in Excel is using the TEXT function: Calculate hours between two times: =TEXT(B2-A2, "h") Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm") Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")
|