Removing Breaks from Smart Formulas

Break Types

In addition to calculating hours from start and end times, Smart Formulas can also be configured to remove breaks automatically.

In order to remove breaks, a type column must be provided in the data that indicates which lines are treated as breaks.

By entering values in the Break Types field, Smart formulas will then remove breaks from any lines that include them (or part of the break). This includes hour based allowances, minimum engagement and start/end based shifts.

Setup

Break Types can have multiple values separated by a comma. Values are not case sensitive, so break will also match BREAK or Break, etc

Importing Data

In order to calculate breaks, the data imported must include a column that can be mapped to Type that will be used to map breaks. The column does not require values for non break columns, but it does for breaks.

Example File:

Import File:

When importing the file, ensure the Type* column is mapped

Breaks are calculated and shown in the validated data: