TIME(hour,minute,second)
hour: hour of the day
minute: minute within the hour
second: second within the minute
The TIME function computes the fractional day after midnight at the time given by hour, minute, and second.
While the return value is automatically formatted to look like a time between 0:00 and 24:00, the underlying serial time value is a number between 0 and 1. If any of hour, minute, and second is negative, #NUM! is returned
This function is Excel compatible.