Expression (exp)

Settings

Setting	Value	Comment
type	"exp"
format	For numeric values: "type:decimals" type can be $, %, # (number) or nothing decimals: number of decimal places (default 2) For date/time: "type:format" type D for date (ISO, US, CAN, MN) type T for time (24H)
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')