{"id":3381,"date":"2014-03-04T11:43:09","date_gmt":"2014-03-04T06:13:09","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3381"},"modified":"2023-09-29T15:22:42","modified_gmt":"2023-09-29T09:52:42","slug":"excel-second-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-second-function\/","title":{"rendered":"Excel SECOND Function | Formula Examples + FREE Video"},"content":{"rendered":"\n

Excel SECOND Function (Examples + Video)<\/span><\/h2>\n\n\n\n
\"EXCEL<\/figure>\n\n\n\n

When to use Excel SECOND Function<\/span><\/h3>\n\n\n\n

Excel SECOND function can be used want to get the integer value of the seconds from a specified time value.<\/p>\n\n\n\n

What it Returns<\/span><\/h3>\n\n\n\n

It returns a value between 0 and 59 depending on the time value used as the input.<\/p>\n\n\n\n

Syntax<\/span><\/h3>\n\n\n\n

=SECOND(serial_number)<\/p>\n\n\n\n

Input Arguments<\/span><\/h3>\n\n\n\n
  • serial_number:<\/strong> the value that contains the time for which the seconds value needs to be determined.<\/li><\/ul>\n\n\n\n

    Additional Notes<\/span><\/h3>\n\n\n\n

    The argument can be provided in different formats:<\/p>\n\n\n\n

    • As a serial number: The integer part of the serial number represents the date, while the decimal portion of it represents time (remember excel stores date and time as serial numbers).\n
        \n
      • If you provide 41640.7813657407 as the serial number, it would return 10 (as the decimal portion 0.7813657407 represents 18 hours, 45 minutes, and 10 seconds).<\/li>\n<\/ul>\n<\/li>
      • As text: =SECOND(“41640.7813657407”) would return 10.<\/li>
      • As a result of some other formula. For example, =SECOND(TIMEVALUE(“6:45:10 PM”)) would return 10.<\/li><\/ul>\n\n\n\n

        Excel SECOND Function – Live Example<\/span><\/h2>\n\n\n\n