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")).
TIMEDIF()
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:
Minutes →
=TIMEDIF(A1,B1)*60Seconds →
=TIMEDIF(A1,B1)*3600
HOUR()
Purpose: Returns the hour component of a time value.
Formula to use:
=HOUR(A1)
Example:
If A1 = 08:45
=HOUR(A1) returns 8
MINUTE()
Purpose: Returns the minute component of a time value.
Formula to use:
=MINUTE(A1)
Example:
If A1 = 08:45
=MINUTE(A1) returns 45
SECOND()
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().
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")