HOUR

HOUR helps you extract the hour value from time data in DBSheet formula fields, returning a number from 0 to 23. It provides the tools you need to calculate hour-based results directly in a table, making your work more efficient and helping you accomplish tasks with ease. With HOUR, you can create a formula field, enter a HOUR formula, use flexible parameter formats, reference target data ranges, combine it with other functions such as IF or AND, and have results update automatically when source data changes or after data import. Whether you're building formulas, checking parameter formats, troubleshooting calculation errors, or setting up nested function logic, HOUR helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53