Re:Maybe I should ask how do I run a function in a macro?
Why would you want to run the Excel worksheet SECOND() function in VBA.
VBA already has a Second function.
Type "Second(" in the VBA window and it will prompt you for time as an argument.
Here is a short macro that will enter the time with seconds in cell A1 and the time rounded down to zero seconds in cell B1.
The code is in the Worksheet("Sheet1") object
Format cells A1 and B1 with "hh:mm:ss"
Run the macro and see the difference.
Dim n As Date
n = Now()
Worksheets("Sheet1").Range("A1").Value = n
Worksheets("Sheet1").Range("B1").Value = n - Second(n) / 86400