Business Hours: Get Time Between
Overview
This action calculates the following times between two Date/Time values using only business hours: minutes, hours.
This action calculates the time between two Date/Time values but only using business hours! If the business hours are defined as 8 hours per day and you get the time between Monday at 12:00 PM and Thursday at 12:00PM this action will return 24 hours, not 72 hours.
Inputs
First Date/Time
The first Date/Time value used to calculate the time between two Date/Times.
| Type |
|---|
| Date/Time |
Second Date/Time
The second Date/Time value used to calculate the time between two Date/Times.
| Type |
|---|
| Date/Time |
Business Hours Id / Name
The Business Hours record Id or Name used to calculate the time between two Date/Times. If empty, the default Business Hours will be used.
| Type |
|---|
| Text |
Absolute Value Output
If set to true, the output values are always a positive number.
| Type | Default |
|---|---|
| Boolean | false |
Rounding Mode
The rounding mode used when calculating the time. The value must be a valid Rounding Mode value.
| Type | Default |
|---|---|
| Text | HALF_EVEN |
Decimal Scale
How many decimal points are used when calculating the time value between two Date/Time fields.
| Type |
|---|
| Number |
Outputs
The outputs are decimal values. For example, if the amount of business hours between two times was 3 hours and 45 mintues the minutes output would be 225 and the hours output would be 3.75.
Minutes
The number of minutes between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | minutes |
Hours
The number of hours between the two Date/Time values.
| Type | Variable Name |
|---|---|
| Number | hours |