Photo by Brooke Cagle on Unsplash

PTO — working days

Why and how I replaced my initial set up

You can see my initial setup for handling daily working hours below.

my initial set up

This setup worked well for calculating daily hours worked, especially when everyone worked full-time. In those cases, a half-day off (for sick leave or holidays) was a simple calculation: 0.5 * daily working hours.

However, as the organization grew, we encountered problems due to the increasing variety in work schedules. We had some employees with long working days (see the first line) and others with shorter variations (like the last line). In these scenarios, a half-day off was no longer accurately represented by 0.5 * daily working hours.

Quick fixes might involve complex and hard-to-maintain SwitchIf() functions, but I'm against implementing those when a review of our current setup could lead to a more flexible and maintainable solution.

A Different Approach

Instead of the typical spreadsheet layout, we’ve shifted this logic to a table structure where rows, not columns, are the defining element. You can see how this works below. Admittedly, this view isn’t…