The VBA SECOND Function

Home » Excel-VBA-Tutorial » VBA-Operators-And-Functions » VBA-Second-Function

Search this site:

Custom Search

Related Function:

VBA MINUTE function

Description

The VBA Second Function returns the second component of a supplied time. The syntax of the function is:

Second( time )

A simple example of the VBA Second function is shown below:

Const CurrTime = "17:56:33"
Dim SecNum As Integer

SecNum = Second(CurrTime)

After running the above snippet of VBA code, the variable 'SecNum' holds the value 33, which is the second component of the supplied time "17:56:33".

Disclaimer