Skip to main content

Round punch time

Round the punch time to an effective time using the provided parameters.

Details​

Rule Type
Time

Execution
Before punch

Parameters​

NameDataTypeDefaultValueDescription
roundtointeger1Round the minutes to this nearest interval; e.g. 1=no rounding, 15=quarter hour
bumpafterinteger1When "roundto" is greater than 1, this is the break point where the minutes round forward to the next "roundto" vs backwards to the prior; e.g. 7=minutes 0 - 7 round back to zero, while minutes 8
  • 15 round forward to 15.

Decision Tree​

Rule processing begins in the cell R1:Level1 and proceeds right/down. Any IF statement which results in a DONE step terminates the rule immediately.

Line#Level1Level2Level3Comment
1Start
2IF(FIND(PunchActions, Type) notin IN,OUT) →↓Only want IN/OUT actions
3↓DONE
4SET(EffectiveTime = ROUND_DATETIME(PunchTime, roundto, bumpafter))Round punch to nearest "roundto"
5DONE