Combined date and time into one column

(optional)

Convert "From-Date/From-Time/To-Time"

2 columns "From" "To"

Compute working hours per duty

Formula operator: Date and Time

column "Hours"

Scale to daily data

Scaling 8.0

Compute daily percentages of account

As a percentage 4.0

column "Percentage"

Format your table and data 

Format columns 2.0

Replacing null values

Rename, reorder and delete columns

General Calendar

column "Date"

Order by date

Sort Rows

Pivot the table

Create Pivot Table V5

columns "worktime", "sick leave", "holiday"

Create TIS Board operator

TIS Board - Adjust portlet if column changes 1.0

TIS Board operators

Create a simple grid portlet

Simple Grid (Portlet)

Conditional Formatting for Grids