Addition
The following matrix shows between which values additions are possible and how they are defined.
| String | Float | Date | Real Timespan | Labor Timespan | Regular Expression |
|---|
String | s | | | | | |
Float | | f | | | | |
Date | | | | d | | |
Real Timespan | | | d | t | t | |
Labor Timespan | | | | t | t | |
Regular Expression | | | | | | |
Additions are possible if the field at the crossing point is not empty.
Type | Explanation | Example |
s | String concatenation. | "An" + "na" = "Anna"
|
f | Standard addition of numbers. | 1.5 + 3 = 4.5
|
t | Standard addition of timespan values based on minutes. If the timespan values do not have the same type (i.e., not both real or both labor), the result has the type of the first operand. | 1w 2d 3h + 2w 2d 2h = 3w 4d 5h
1D + 1h = 1D 1H
|
d | The timespan value is added to the date. If the date has no entered time, hours and minutes do not matter. | (12.10.2016 + 14H) + 12H = 12.10.2016, 12.10.2016 + 1W 3D = 22.10.2016
|
Subtraction
The following matrix shows between which values subtractions are possible and how they are defined.
| String | Float | Date | Real Timespan | Labour Timespan | Regular Expression |
|---|
String | | | | | | |
Float | | f | | | | |
Date | | | | d | | |
Real Timespan | | | d | t | t | |
Labor Timespan | | | | t | t | |
Regular Expression | | | | | | |
Subtractions are possible if the field at the crossing point is not empty.
Type | Explanation | Example |
f | Standard subtraction of numbers. | 4.5 - 3 = 1.5
|
t | The subtraction of two timespans returns the absolute difference based on minutes. If the the timespan values do not have the same type (i.e., not both real or both labor), the result has the type of the first operand. | 8w 1d 3h - 8w 2d 4h 9min = 1d 1h 9min
2h - 1H = 1h
|
d | The timespan value is subtracted from the date. If the date has no entered time, hours and minutes do not matter. | (29.05.2015 - 12H 5MIN) - 12H 5MIN = 29.05.2015, 29.11.2019 - 6D = 23.11.2019
|
The subtraction of Date values is not supported. Use, e.g., {Date A} < {Date B} + 1W instead of comparing the difference of the dates to a week.