Select the type of your day, values change accordingly. Workdays are 7.5 hours, holidays 0 hours, so it's easy to keep track of overtime done either in workday or on holiday.
For extra minimalism, turn off:
View > Column & Row Headers
View > Formula Bar
View > Toolbars > Formatting
There are hidden rows used in the sheet. Unhide them by selecting a row of columns and select 'Show Columns'
You may need to change the LibreOffice Calc Language settings by going to:
Tools > Options > Language Settings > Languages
Nicer font: Download - Close the hour list
- Install the font
- Open the hour list again
You can unfreeze the top to rows by going to:
View > Freeze Cells > Freeze Rows and Columns
Extra information for adding more day types (advanced):
- The Day type config settings are in the config tab.
- Data → Define range... should be used for defining the range for day_type
(which is the range that's in use in Data → Validity. One of the Day type cells needs to be selected.)
- Select one of the Day type cells and go to Format → Conditional Formatting → Condition... in order to add new formatting stuff there.
- Copy the modified 'Day type' cell over the old ones (use Paste Special... to not override the formatting, like the borders)