--- title: "Time Calculation" slug: "time-calculation" updated: 2024-02-02T11:33:18Z published: 2024-02-02T11:33:18Z canonical: "kb.dataparc.com/time-calculation" --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.dataparc.com/llms.txt > Use this file to discover all available pages before exploring further. # Time Calculation The Time Calculation function calculates the amount of time a tag’s value meets certain criteria within a given interval. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image036_007.jpg) Manually specify the **Start date** and **End date** of the function’s interval or use cell references. Specify the conditions to evaluate with **Criteria**. Select the logical operator with the drop-down menu. Either type a fixed value into the text entry fieldor click ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image020_002.png) to select a cell’s value. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image038_008.jpg) Alternatively, open the Tag Browser with the ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image019_006_19x19.png) button and drag a tag into the Criteria text entry field. Check T **ag** in the Criteria section to use the value of the tag. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image040_009.jpg) Use two conditions to calculate the amount of time the base UTag’s value was inside a given range of numeric values. Select a **Return type** to determine the kind of data returned by the function. ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image042_008.jpg) **Total duration matching criteria:** Sums the durations of the intervals that meet the criteria. **Duration of each interval:** Returns a list or array of the durations of each interval. Enter a value in Max rows to specify the number of rows in the list. **Durations and start times:** Returns a list or array of the durations and start times of each interval. Enter a value in Max rows to specify the number of rows in the list. Select the Units of the data. Choose % to see the duration(s) returned as a percentage of the function’s interval. Select a time-based unit to see the duration(s) returned in seconds (S), minutes (M), hours (H), or days (D). ![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image044_006.jpg) Click OK. The function can be viewed in the formula bar.