This other function is used as another numerical output [0-59] input time
Another feature: a short
Its Second Function Excel extracts seconds part of the given entry time and return the number 0 and 59To.
For example, if time is 05:45:43 AM” Second The feature returns 43To. With this feature, you can pull out seconds and display them in a separate cell.
|
Objective |
The value was returned by function |
|---|---|
|
Aim Seconds as a numeric value |
Another feature returns numeric values from seconds 0 to 59 Input of time value. |
Function Compatibility:
Its Second The function was introduced in the year Excel 2000To. It is supported in all modern versions of Excel including Excel 2003, 2007, 2010, 2013, 2016, 2019 and Microsoft 365To.
Another feature: Syntax
=SECOND(input_time)
- Input_value: The input value must be a valid Excel time.
Main example:
Example below will help you understand how Second The function works in Excel.
|
Input time |
Output seconds |
The formula used |
|---|---|---|
|
12:45:38 |
38 |
= Second (B3) |
|
05:22:59 |
59 |
= Second (B4) |
|
23:10:07 |
7 |
= Second (B5) |
Shown from the example Second The function extracts seconds part of the given time and return it as a numberTo.
Note: Restriction Second The feature is that Round a fraction of seconds to the nearest second.
In the example shown Second The function is used to extract seconds in the column listed The bwhich includes values in the year a second of a hundredTo. There is a fraction of a fraction of this process ignoredand the value is rounded to the next second.
|
Input time in a fraction of seconds |
Turning off the final round for seconds output |
The 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) |
For the input time “05: 12.09”” Second The feature returns 12 secondsAs the fractional part (.09) is smaller than 0.50So it doesn't round. However, for input time “04: 50.77”” Second The feature returns 51 secondsAs the fractional part (.77) is greater than 0.50So it rounds to the next second.
You can pull the second value out of time. You may need to use =NOW() feature to get the current time and then you need to use =SECOND(NOW()) Formula.
Using the current and second function to return the value of a second of a second.
|
Functions used |
Description |
|---|---|
|
= Now () |
It is used to get the current time value. |
|
= Another () |
It is used to get the value of seconds from the entry time. |
|
= Another (now () |
It is used to obtain seconds from the present time. |
Mining seconds from the current time value.
Example 5: Using the function of seconds with time function:
You can use Seconds feature together Time function seconds value of the result of the result Time Function.
=SECOND(B4 + TIME(0,1,25))
=SECOND(B4 + TIME(0,1,45))
For this input time in the box “01:15:40” is the output value of the cell C4 appears 5 because 40s + 25s = 65 seconds equal to 1 minute and 5 seconds And so this feature returns the value 5.
Example 6: Using another function with other nested features:
|
Input time |
Output results |
The formula used |
Description |
|---|---|---|---|
|
13:25:46 |
50 |
= Second (Timevalue (Mean (A1.13.8))) |
Minutes the time from the text string and gets seconds. |
|
20-03-2025 17:48 |
Less than 30 seconds |
= Text (now (), “hh: mm: ss”) & “(seconds:” & seconds (now ()) “)” |
This combination of formula displays something like this: “15:27:45 (seconds: 45)” |
|
65 |
5 |
= Second (time (0.0, mod (A1.60))) |
If the cell has 65 (seconds), it calculates the remaining seconds (65 seconds = 1 minute and 5 seconds). |
|
20-03-2025 17:48 |
17:48:21 (seconds: 21) |
= If (second (now (now ()) 30, “over 30 seconds”, “less than 30 seconds”) |
This combination of the formula dynamically shows, either over 30 seconds or less than 30 seconds, based on the current second. |
|
Time is 12:45:33 |
33 |
= Round (second (a1)/10.0) * 10 |
It rounds seconds to the nearest 10 |
That's it. This tutorial is originally published on how to use another function in Excel?
