Last updated: August 26, 2026.
The TimeSerial function constructs a time value from hour, minute, and second parts.
Syntax
TimeSerial(hour, minute, second)| Argument | Description |
|---|---|
hour | Hour part |
minute | Minute part |
second | Second part |
Examples
TimeSerial(14, 30, 0) ' 2:30 PM
TimeSerial(8, 75, 0) ' 9:15 AM
StartTime: TimeSerial([HourPart], [MinutePart], 0)Out-of-range parts are normalized into adjacent units. Validate input when normalization would conceal an invalid time.
See Microsoft’s Access function reference for related expression functions.
