Last updated
Last updated
Calculates difference between start time value and end time value and returns the number based on requested unit
timeDiff({start-time-field}, {end-time-field}, 'unit')
start-time-field: Date or Time field ID that contains start time
end-time-field: Date or Time field ID that contains end time
unit: one of the followings surrender by single quote
seconds
minutes
hours
days
months
years
Example: timeDiff({start_time}, {end_time}, 'hours')
type
"exp"
format
"type:decimals" type can be $, %, # (number) or nothing decimals: number of decimal places (default 2)
expression
the expression to be calculated. In the expression can use other field values by putting field ID in {}
example: {height} * {width}