| Formula Functions > Functions T to Z > TIME |
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
This function is available in product version 1.0 or later.
HOUR | MINUTE | DAY | NOW | TODAY | Date and Time Functions