Calculate the time difference between the start time and the end time.
The results can be directly entered into the field or referenced from other actions.
Specify the “Start Time” and “End Time”. You can specify the values of time fields and date-time fields using expressions.
The fraction will be discarded.
When both the start and end are dates, the time difference is calculated including the date. For example, from 2019-03-11 12:00 to 2019-03-12 14:00, the results will be 26 hours instead of 2 hours.
If both the start and end times do not have dates, they are considered to be on the same day. If the start time is 23:00 and the end time is 01:00, the results will be minus 22 hours. It will not be plus two hours.
If one of the start or end has a date and the other does not, the one without a date is considered to be the same day as the one with a date. At this time, “the same day” is determined based on the time zone of the user logged into Kintone.
If the end is in the past compared to the start, the result will be a negative value.
To set the result of the calculation to another field, enter the target field into the parameter “Target Field (Optional)”.
Use formulas when using the results for other actions without obtaining the results immediately.
When you execute an action to run “Calculates Time Difference”, the result of the calculation is stored internally. The value is saved as a numeric figure without any accompanying unit. You can get the saved results by using a formula, for example “=$1”.
Set Start Time, End Time, and Target Field.
Specify the start time. You can specify the values of time fields and date and time fields using expressions.
To access the value of a Time field or a Date and time field, use the field code:
Example: =Time_2
insert an equals sign “=” before the field code, as in the example.
To specify the current time, write as follows:
=now()
Specify the end time.
Like the start time, it is possible to reference the values of time fields or date and time fields using expressions, or to specify the current date and time.
You can choose to calculate in hours or in minutes.
Seconds cannot be accepted.
Use this parameter to set the results to another field. You can leave this parameter empty to use the calculation result in another action without setting it to any field.
Only numerical values in specified units will be set. No unit name is attached.
If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)
*1: Only the affected rows will be processed if you set a condition that applies only to some table rows (such as “When Fields Value Changed”).
This parameter accepts the following field types:
This action is designed to work seamlessly with krewSheet.
However, the following restrictions apply to the parameter “Target Field (Optional)":