VBA - Time Serial Function


Advertisements

The TimeSerial function returns the time for the specified hour, minute, and second values.

Syntax

TimeSerial(hour,minute,second) 

Parameter Description

  • Hour − A required parameter, which is an integer between 0 and 23 or any numeric expression.

  • Minute − A required parameter, which is an integer between 0 and 59 or any numeric expression.

  • Second − A required parameter, which is an integer between 0 and 59 or any numeric expression.

Example

Add a button and add the following function.

Private Sub Constant_demo_Click()
   msgbox(TimeSerial(20,1,2))
   msgbox(TimeSerial(0,59,59))
   msgbox(TimeSerial(7*2,60/3,15+3))
End Sub

When you execute the above function, it produces the following output.

8:01:02 PM
12:59:59 AM
2:20:18 PM
vba_date_time.htm
Advertisements