Dashpivot supports Excel-style time functions inside Default Tables and Prefilled Tables, helping you automate time tracking, reporting, and calculations.

Note: Time formulas often return a decimal (fraction of a full day). Use TEXT() to format results (e.g. =TEXT(TIME(A1,B1,0),"HH:MM")).

Purpose: Calculates the difference between two times (in hours).
​Formula to use:
​=TIMEDIF(A1,B1)

Example:
If A1 = 01:00
and B1 = 03:30
​=TIMEDIF(A1,B1) returns 2.5

To convert:

Purpose: Returns the hour component of a time value.
​Formula to use:
​=HOUR(A1)

Example:
If A1 = 08:45
​=HOUR(A1) returns 8

Purpose: Returns the minute component of a time value.
​Formula to use:
​=MINUTE(A1)

Example:
If A1 = 08:45
​=MINUTE(A1) returns 45

Purpose: Returns the second component of a time value.
​Formula to use:
​=SECOND(A1)

Example:
If A1 = 08:45:30
​=SECOND(A1) returns 30

Commonly used with NOW().

Purpose: Returns the current date and time. The decimal portion represents the time.
​Formula to use:
​=NOW()

Example:
If the current date is 05/08/2024 at 14:30
​=NOW() returns a serial number such as 45509.60

To format as readable date/time:
​=TEXT(NOW(),"DD/MM/YYYY HH:MM")

Note: NOW() recalculates every time the form is opened or saved.

Purpose: Returns the current date (without time). Recalculates each time the form is opened or saved.
​Formula to use:
​=TODAY()

Example:
​=TODAY()-A1 — returns the number of days since the date in A1. Useful for calculating how many days since a form was submitted or an action was recorded.

Purpose: Builds a time value from separate hour, minute, and second components.
​Formula to use:
​=TIME(A1,B1,0)

Example:
If A1 = 8 (hours) and B1 = 30 (minutes)
​=TIME(A1,B1,0) returns 08:30.
Combine with TIMEDIF() to calculate total hours worked between a start time built from components.

Why does my time formula show a decimal like 0.5 instead of a time?
Time values in Dashpivot are stored as fractions of a full day (e.g. 0.5 = 12 hours). Wrap your formula in TEXT() to display it as a readable time: =TEXT(A1,"HH:MM").