TIME

From LongJump Support Wiki

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'