Break Types
In addition to calculating hours from start and end times, Smart Formulas can also be configured to remove breaks automatically if your file contains them. 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
Break Types field in Smart Formula settings
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
Sample file with break types
Import File
When importing the file, ensure the Type column is mapped as it is the values in this column that will be used to determine if the row is a break or not.Breaks are calculated and shown in the validated data
Validated data with breaks calculated