LibreOffice 24.8 Help
TIME returns the current time value from values for hours, minutes and seconds. This function can be used to convert a time based on these three elements to a decimal time value.
TIME(hour; minute; second)
Use an integer to set the hour.
Use an integer to set the minute.
Use an integer to set the second.
TIME(0;0;0) returns 00:00:00
TIME(4;20;4) returns 04:20:04