Round up the time to the nearest minute. You can reference the result from other actions.
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 setting the results to another field immediately.
When you execute an Action set to run “Round Up Time”, the result of that action is stored internally. You can get the saved results by using a formula, for example “=$1”.
If the value of the “Time” parameter is in a format that does not include a date, the calculation result will be in a format 09:30. Seconds are not included. It is formatted so that it can be set directly in the Time field of Kintone. However, the saved date does not contain any date data, so it cannot be set to a Date and time field.
If the value of the “Time” parameter is in a format that includes a date, it will be calculated including the date, and the result will also be in a format that includes the date. The format of the result will be based on Coordinated Universal Time, such as 2019-09-06T03:16:00.000Z. This format can be set directly to the date and time field of Kintone.
Example: Use the calculated time results in another action, “Add New Record.”
Set Time, Round Up Minute, and Target Field (Optional).
Enter the reference time to be used in the time calculation.
Both formats, including only the time, such as 09:30, and format including both date and time, such as 2019-09-12 09:30, can be specified.
If specified in a format that includes a date, it will be calculated including the date. For example, if you round up 2019-09-12 23:30 to 60 minutes, the results 2019-09-13 00:00.
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, enter
=now()
This will set the current time as the value of this parameter.
Specify the rounding unit in minutes.
You need to specify a “round” number that divides 24 hours (1440 minutes) evenly. For example, 10, 15, 30 … etc. can be specified.
Values exceeding one hour, such as 60 or 120, can also be specified. If rounding up in units exceeding 60 minutes, the results will vary depending on the user’s time zone settings. For example, if the user’s time zone is set to JPT, the rounding will be based on Japan time.
Negative values cannot be specified.
You cannot specify it in the formula.
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.
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):”
In the case of a format that does not include a date, the calculation result will be between 00:00 and 23:59. For example, if you round up 23:30 by 60 minutes, the result will be 00:00, not 24:00.
Even if the “Time” parameter includes seconds, the seconds part is ignored, and the result does not include seconds. For example, the result of rounding up “08:30:15” by 30 minutes will ignore the seconds part, so it will be “08:30” instead of “09:00:00”.