In Access, the TimeSerial function returns the time for a specific hour, minute, and second.
The syntax for the TimeSerial function is:
TimeSerial ( hour, minute, second )
The TimeSerial function returns a time that is stored internally as a double-precision fractional number between 0 and 0.99999. This number represents a time between 0:00:00 and 23:59:59, or 12:00:00 A.M. and 11:59:59 P.M., inclusive. If the time specified by the three arguments, either directly or by expression, falls outside the acceptable range of times, an error occurs.
hour is a number between 0 (12:00 A.M.) and 23 (11:00 P.M.), inclusive, or a numeric expression.
minute is a number between 0 and 59, inclusive, or a numeric expression.
second is a number between 0 and 59, inclusive, or a numeric expression.
Examples
TimeSerial (15,3,24) returns 3:03:24 PM TimeSerial (11,-5,24) returns 11:55:24 AM TimeSerial (10,39-5,43) returns 10:34:43 AM
VBA Code
Dim MyTime As Date MyTime = TimeSerial(15,3,24)
This example uses the TimeSerial function to return a time for the specified hour, minute, and second. Now the MyTime variable would contain the value of '3.03.24 PM'.
SQL query
You can also use the TimeSerial function in a query.