MS Access TimeSerial() Function

Return a time from it's parts:

SELECT TimeSerial(15, 9, 20);

Definition and Usage

The TimeSerial() function returns a time from the specified parts (hour, minute, and second value).

TimeSerial(hour, minute, second)

Parameter	Description
hour	Required. Specifies the hour (an integer between 0 and 23)
minute	Required. Specifies the minute (an integer between 0 and 59)
second	Required. Specifies the seconds (an integer between 0 and 59)

Works in:	From Access 2000

Return a time from it's parts:

SELECT TimeSerial(12-2, 40-5, 20-5);