TimeSerial function

Category: Date & Time

Summary

Time from parts.

Syntax

TimeSerial(hour, minute, second) The TimeSerial function syntax has these named arguments:
Part
Description
hourRequired; Variant (Integer). Number between 0 (12:00 A.M.) and 23 (11:00 P.M.), inclusive, or a numeric expression.
minuteRequired; Variant (Integer). Any numeric expression.
secondRequired; Variant (Integer). Any numeric expression.

Example

Example
This example uses the TimeSerial function to return a time for the specified hour, minute, and second.
Dim MyTime
MyTime = TimeSerial(16, 35, 17) ' MyTime contains serial
' representation of 4:35:17 PM.

Microsoft Support Page

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/timeserial-function

Back to Functions