Expression (exp)

Settings

Setting
Value
Comment

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}

Functions

Time Difference

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')

Last updated