This function returns the TimeSpan object for a specified time.
TIME(hour,minutes,seconds)
This function has these arguments:
Argument | Description |
---|---|
hour | Hour as a number from 0 to 23. |
minutes | Minutes as a number from 0 to 59. |
seconds | Seconds as a number from 0 to 59. |
Accepts numeric data for all arguments. Returns a TimeSpan object.
TIME(A1,B1,C1)
TIME(R1C1,R1C2,R1C3)
TIME(12,0,0) gives the result 12:00:00
TIME(16,48,10) gives the result 16:48:10