This SECOND Function is used to return the Second as a numerical output [0-59] from a input Time SECOND Function: A Brief The SECOND function in Excel extracts the seconds part of a given input time and returns a number between 0 and 59. SECOND seconds 0 and 59 For example, if the time is 05:45:43 AM, the SECOND function will return 43. You can use this function to pull out the seconds and display them in a separate cell. 05:45:43 AM SECOND 43 Objective

Value Returned by function



Aim to get the Seconds as a numerical value

SECOND Function will return a numeric values of seconds from 0 to 59 from the input time value. Objective

Value Returned by function



Aim to get the Seconds as a numerical value

SECOND Function will return a numeric values of seconds from 0 to 59 from the input time value. Objective

Value Returned by function Objective Objective Value Returned by function Value Returned by function Aim to get the Seconds as a numerical value

SECOND Function will return a numeric values of seconds from 0 to 59 from the input time value. Aim to get the Seconds as a numerical value Aim to get the Seconds as a numerical value Seconds as a numerical value SECOND Function will return a numeric values of seconds from 0 to 59 from the input time value. SECOND Function will return a numeric values of seconds from 0 to 59 from the input time value. 0 59 Function Compatibility: The SECOND function was introduced in Excel 2000. It is supported in all modern versions of Excel, including Excel 2003, 2007, 2010, 2013, 2016, 2019, and Microsoft 365. SECOND Excel 2000 Excel 2003, 2007, 2010, 2013, 2016, 2019, and Microsoft 365 SECOND Function: A Syntax =SECOND(input_time) =SECOND(input_time) input_value: The input value must be a valid excel time. input_value: The input value must be a valid excel time. input_value Basic Example: The example below will help you understand how the SECOND function works in Excel. SECOND Input Time

Output Seconds

Formula Used



12:45:38

38

=SECOND(B3)



05:22:59

59

=SECOND(B4)



23:10:07

7

=SECOND(B5) Input Time

Output Seconds

Formula Used



12:45:38

38

=SECOND(B3)



05:22:59

59

=SECOND(B4)



23:10:07

7

=SECOND(B5) Input Time

Output Seconds

Formula Used Input Time Input Time Output Seconds Output Seconds Formula Used Formula Used 12:45:38

38

=SECOND(B3) 12:45:38 12:45:38 38 38 =SECOND(B3) =SECOND(B3) 05:22:59

59

=SECOND(B4) 05:22:59 05:22:59 59 59 =SECOND(B4) =SECOND(B4) 23:10:07

7

=SECOND(B5) 23:10:07 23:10:07 7 7 =SECOND(B5) =SECOND(B5) From the example shown, the SECOND function extracts the seconds part from the given time and returns it as a number. SECOND seconds number Example 2: Extracting Seconds from Fractional seconds: Note: The limitation of the SECOND function is that it rounds fractional seconds to the nearest whole second. Note: The limitation of the SECOND function is that it rounds fractional seconds to the nearest whole second. Note: SECOND rounds fractional seconds In the example shown, the SECOND function is used to extract seconds from the times listed in column B, which include values in hundredths of a second. During this process, the fractional part is ignored, and the value is rounded off to the nearest second. SECOND B hundredths of a second ignored rounded off Input Time with Fractional Seconds

Final Round off Seconds Output

Formula used



01:50.82

51

=SECOND(B4)



03:12.45

12

=SECOND(B5)



05:33.19

33

=SECOND(B6)



02:45.67

46

=SECOND(B7)



04:22.98

23

=SECOND(B8)



07:05.21

5

=SECOND(B9)



06:48.36

48

=SECOND(B10)



08:10.73

11

=SECOND(B11)



09:59.44

59

=SECOND(B12)



02:33.85

34

=SECOND(B13)



05:12.09

12

=SECOND(B14)



04:50.77

51

=SECOND(B15) Input Time with Fractional Seconds

Final Round off Seconds Output

Formula used



01:50.82

51

=SECOND(B4)



03:12.45

12

=SECOND(B5)



05:33.19

33

=SECOND(B6)



02:45.67

46

=SECOND(B7)



04:22.98

23

=SECOND(B8)



07:05.21

5

=SECOND(B9)



06:48.36

48

=SECOND(B10)



08:10.73

11

=SECOND(B11)



09:59.44

59

=SECOND(B12)



02:33.85

34

=SECOND(B13)



05:12.09

12

=SECOND(B14)



04:50.77

51

=SECOND(B15) Input Time with Fractional Seconds

Final Round off Seconds Output

Formula used Input Time with Fractional Seconds Input Time with Fractional Seconds Final Round off Seconds Output Final Round off Seconds Output Formula used Formula used 01:50.82

51

=SECOND(B4) 01:50.82 01:50.82 51 51 =SECOND(B4) =SECOND(B4) 03:12.45

12

=SECOND(B5) 03:12.45 03:12.45 12 12 =SECOND(B5) =SECOND(B5) 05:33.19

33

=SECOND(B6) 05:33.19 05:33.19 33 33 =SECOND(B6) =SECOND(B6) 02:45.67

46

=SECOND(B7) 02:45.67 02:45.67 46 46 =SECOND(B7) =SECOND(B7) 04:22.98

23

=SECOND(B8) 04:22.98 04:22.98 23 23 =SECOND(B8) =SECOND(B8) 07:05.21

5

=SECOND(B9) 07:05.21 07:05.21 5 5 =SECOND(B9) =SECOND(B9) 06:48.36

48

=SECOND(B10) 06:48.36 06:48.36 48 48 =SECOND(B10) =SECOND(B10) 08:10.73

11

=SECOND(B11) 08:10.73 08:10.73 11 11 =SECOND(B11) =SECOND(B11) 09:59.44

59

=SECOND(B12) 09:59.44 09:59.44 59 59 =SECOND(B12) =SECOND(B12) 02:33.85

34

=SECOND(B13) 02:33.85 02:33.85 34 34 =SECOND(B13) =SECOND(B13) 05:12.09

12

=SECOND(B14) 05:12.09 05:12.09 12 12 =SECOND(B14) =SECOND(B14) 04:50.77

51

=SECOND(B15) 04:50.77 04:50.77 51 51 =SECOND(B15) =SECOND(B15) For the input time “05:12.09”, the SECOND function returns 12 seconds, as the fractional part (.09) is less than 0.50, so it does not round up. However, for the input time “04:50.77”, the SECOND function returns 51 seconds, because the fractional part (.77) is greater than 0.50, so it rounds up to the next second. “05:12.09” SECOND 12 seconds 0.50 “04:50.77” SECOND 51 seconds 0.50 Example 3: Extracting Seconds from the Present Time: You can extract the second value from the current time. You might need to use the =NOW() function to get the current time and then you need to use the =SECOND(NOW()) formula. =NOW() =SECOND(NOW()) Using NOW and SECOND function to return the seconds value from the current time. Functions Used

Description



=NOW()

It is used to get the current time value.



=SECOND()

It is used to get the seconds value from the given input time.



=SECOND(NOW())

It is used to get the seconds value from the current time. Functions Used

Description



=NOW()

It is used to get the current time value.



=SECOND()

It is used to get the seconds value from the given input time.



=SECOND(NOW())

It is used to get the seconds value from the current time. Functions Used

Description Functions Used Functions Used Description Description =NOW()

It is used to get the current time value. =NOW() =NOW() It is used to get the current time value. It is used to get the current time value. =SECOND()

It is used to get the seconds value from the given input time. =SECOND() =SECOND() It is used to get the seconds value from the given input time. It is used to get the seconds value from the given input time. =SECOND(NOW())

It is used to get the seconds value from the current time. =SECOND(NOW()) =SECOND(NOW()) It is used to get the seconds value from the current time. It is used to get the seconds value from the current time. Extract the seconds from the current time value. Example 5: Using SECONDS Function with TIME Function: You can use the SECONDS function along with the TIME function to extract the seconds value from the result given by the TIME function. SECONDS TIME seconds TIME =SECOND(B4 + TIME(0,1,25)) =SECOND(B4 + TIME(0,1,25)) =SECOND(B4 + TIME(0,1,45)) =SECOND(B4 + TIME(0,1,45)) For a given input time in the cell “01:15:40”, the output value in the cell C4 will be shown as 5, because 40s + 25s = 65 seconds, which equals 1 minute and 5 seconds and so this function returns the value 5. C4 40s 25s 65 1 minute 5 seconds Example 6: Using SECOND Function with other Nested Functions: Input Time

Output Results

Formula Used

Description



13:25:46

50

=SECOND(TIMEVALUE(MID(A1,13,8)))

Extracts the time portion from a text string and gets the seconds.



20-03-2025 17:48

Under 30 seconds

=TEXT(NOW(),"hh:mm:ss") & " (Seconds: " & SECOND(NOW()) & ")"

This formula combination will display something like: “15:27:45 (Seconds: 45)”



65

5

=SECOND(TIME(0,0,MOD(A1,60)))

If the cell has 65 (seconds), it calculates the leftover seconds after converting to minutes (65 seconds = 1 minute and 5 seconds).



20-03-2025 17:48

17:48:21 (Seconds: 21)

=IF(SECOND(NOW()) > 30, "Over 30 seconds", "Under 30 seconds")

This formula combination will dynamically show either “Over 30 seconds” or “Under 30 seconds” based on the current time’s seconds value.



The time is 12:45:33

33

=ROUND(SECOND(A1)/10,0) * 10

This will round the seconds to the nearest 10 Input Time

Output Results

Formula Used

Description



13:25:46

50

=SECOND(TIMEVALUE(MID(A1,13,8)))

Extracts the time portion from a text string and gets the seconds.



20-03-2025 17:48

Under 30 seconds

=TEXT(NOW(),"hh:mm:ss") & " (Seconds: " & SECOND(NOW()) & ")"

This formula combination will display something like: “15:27:45 (Seconds: 45)”



65

5

=SECOND(TIME(0,0,MOD(A1,60)))

If the cell has 65 (seconds), it calculates the leftover seconds after converting to minutes (65 seconds = 1 minute and 5 seconds).



20-03-2025 17:48

17:48:21 (Seconds: 21)

=IF(SECOND(NOW()) > 30, "Over 30 seconds", "Under 30 seconds")

This formula combination will dynamically show either “Over 30 seconds” or “Under 30 seconds” based on the current time’s seconds value.



The time is 12:45:33

33

=ROUND(SECOND(A1)/10,0) * 10

This will round the seconds to the nearest 10 Input Time

Output Results

Formula Used

Description Input Time Input Time Output Results Output Results Formula Used Formula Used Description Description 13:25:46

50

=SECOND(TIMEVALUE(MID(A1,13,8)))

Extracts the time portion from a text string and gets the seconds. 13:25:46 13:25:46 50 50 =SECOND(TIMEVALUE(MID(A1,13,8))) =SECOND(TIMEVALUE(MID(A1,13,8))) Extracts the time portion from a text string and gets the seconds. Extracts the time portion from a text string and gets the seconds. 20-03-2025 17:48

Under 30 seconds

=TEXT(NOW(),"hh:mm:ss") & " (Seconds: " & SECOND(NOW()) & ")"

This formula combination will display something like: “15:27:45 (Seconds: 45)” 20-03-2025 17:48 20-03-2025 17:48 Under 30 seconds Under 30 seconds =TEXT(NOW(),"hh:mm:ss") & " (Seconds: " & SECOND(NOW()) & ")" =TEXT(NOW(),"hh:mm:ss") & " (Seconds: " & SECOND(NOW()) & ")" This formula combination will display something like: “15:27:45 (Seconds: 45)” This formula combination will display something like: “15:27:45 (Seconds: 45)” 65

5

=SECOND(TIME(0,0,MOD(A1,60)))

If the cell has 65 (seconds), it calculates the leftover seconds after converting to minutes (65 seconds = 1 minute and 5 seconds). 65 65 5 5 =SECOND(TIME(0,0,MOD(A1,60))) =SECOND(TIME(0,0,MOD(A1,60))) If the cell has 65 (seconds), it calculates the leftover seconds after converting to minutes (65 seconds = 1 minute and 5 seconds). If the cell has 65 (seconds), it calculates the leftover seconds after converting to minutes (65 seconds = 1 minute and 5 seconds). 20-03-2025 17:48

17:48:21 (Seconds: 21)

=IF(SECOND(NOW()) > 30, "Over 30 seconds", "Under 30 seconds")

This formula combination will dynamically show either “Over 30 seconds” or “Under 30 seconds” based on the current time’s seconds value. 20-03-2025 17:48 20-03-2025 17:48 17:48:21 (Seconds: 21) 17:48:21 (Seconds: 21) =IF(SECOND(NOW()) > 30, "Over 30 seconds", "Under 30 seconds") =IF(SECOND(NOW()) > 30, "Over 30 seconds", "Under 30 seconds") This formula combination will dynamically show either “Over 30 seconds” or “Under 30 seconds” based on the current time’s seconds value. This formula combination will dynamically show either “Over 30 seconds” or “Under 30 seconds” based on the current time’s seconds value. The time is 12:45:33

33

=ROUND(SECOND(A1)/10,0) * 10

This will round the seconds to the nearest 10 The time is 12:45:33 The time is 12:45:33 33 33 =ROUND(SECOND(A1)/10,0) * 10 =ROUND(SECOND(A1)/10,0) * 10 This will round the seconds to the nearest 10 This will round the seconds to the nearest 10 That’s it. This tutorial is originally published on How to Use SECOND Function in Excel? How to Use SECOND Function in Excel

This story will praise and/or roast a product, company, service, game, or anything else people like to review on the Internet.

Learn How to Use the SECOND Function to Retrieve Second Values from Input Time?

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Essential Excel Shortcuts to Speed Up Your Daily Tasks!

Reading 1 Million+ Row Excel Files in Java Without Killing Your Memory: Meet Sjxlsx

Excel Formulas for Assigning Categories by Value Range Using Functions!

How Do I Find the Cell That Contains the Maximum or Minimum Value in Excel?

How to Instantly Delete All Objects and AutoShapes in Excel

Step-by-Step: Transform Text Case in Excel Using Formula

Essential Excel Shortcuts to Speed Up Your Daily Tasks!

Reading 1 Million+ Row Excel Files in Java Without Killing Your Memory: Meet Sjxlsx

Excel Formulas for Assigning Categories by Value Range Using Functions!

How Do I Find the Cell That Contains the Maximum or Minimum Value in Excel?

How to Instantly Delete All Objects and AutoShapes in Excel

Step-by-Step: Transform Text Case in Excel Using Formula

Light-Mode

Classic

Newspaper

Minty

Dark-Mode

Neon Noir

Minty

HN StartUps