DURATION

DURATION helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter the function quickly, use flexible parameters for different calculation scenarios, and keep results updated automatically when source data changes. With DURATION, you can write formulas directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use cross-sheet references, and build nested calculations. If an error appears, you can check syntax, parameter count and types, bracket matching, separators, text-formatted numbers, or circular references, and trigger recalculation when needed. Whether you're creating formulas for routine calculations or troubleshooting incorrect results, DURATION helps you work efficiently and accurately. Choose the documentation below that best matches your needs to learn more.

1:53