DURATION

DURATION helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter the DURATION function quickly, use flexible parameters for different calculation scenarios, and work more efficiently with automatically updated results when source data changes. With DURATION, you can enter the formula in a cell or formula bar, view syntax prompts with parameter requirements and examples as you type, use cross-worksheet references, and build nested calculations. If errors occur, you can check syntax, parameter types, parameter counts, unmatched parentheses, missing separators, text-formatted numbers, or circular references, and manually recalculate when needed. Whether you're writing formulas, validating inputs, or troubleshooting incorrect results, DURATION 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