Absence duration between dates when absence start/end spans calendar month

Summary:

How to report on absences duration within a given month, even if absence starts or ends outside of that month.

Content (required):

We have a requirement to report on absences in each calendar month. Let's take May 2022 as an example month. When we run our analysis it shows absences that started in May 2022 and ended after that month, but the duration shows as the total duration, not just the duration for May 2022. It also does not show absences that started prior to May 2022, e.g. absence that started in April 2022 and ended in May 2022 or beyond. Is there a way to achieve this please?