- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
TIME
This function returns the TimeSpan object for a specified time.
Syntax
TIME( hour, minutes, seconds )
Arguments
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. |
Data Types
Accepts numeric data for all arguments. Returns a TimeSpan object.
Examples
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.