TIME

The TIME function creates a datetime from hours and minutes.

Syntax

TIME(hours, minutes)

Return

Date in the format defined by Date Format

Example

TIME(2,45) = '02:45:00'
TIME(15,45) = '15:45:00'