Excel VBA Second Function
Excel VBA Second Function: The Second function in VBA returns the second element for the specified time.
Syntax
Second (Time)
Parameter
Time (required) – This parameter represents the time.
Return
This function returns the second element for the specified time.
Example 1
Sub SecondFunction_Example1() ' returns the current time Dim second_val As Single Const time_val = "17:26:53" second_val = Second(time_val) ' The variable second_val will return 53 Cells(1, 1).Value = second_val End Sub
Output
53
Example 2
Sub SecondFunction_Example2() ' returns the current second Dim second_val As Single time_val = Time() second_val = Second(time_val) ' The variable second_val will return 27 Cells(1, 1).Value = second_val End Sub
Output
27