How to get absence duration per pay period for an qualification plan absence

Summary:

Team - I'm trying to fetch the total sick absence days applied in an accrual period using fast formula. None of the absence FF Functions work for me, if my absence has an overlap of start/end date with accrual start/end date.

For Example, I need to fetch the sick leave days from Feb 1st to Feb 15th. I have 2 absence entries, one from Jan 30 to 3rd Feb (5 days) and another one with Feb 13 to Feb 17 (5 days). My result should be Feb 1, 2, 3 and Feb 13,14 15 (6 days).

None of the FF functions help me in getting the hours.

GET_ABSENCE_DAYS_PER_TYPE