How to Get Daily Absence Records for Multi‑Day Absences in OTL Fast Formula

Summary:

The requirement is to get Absences by Day if the Absence span more than a day

Content (please ensure you mask any confidential information):

In our Time and Labor Fast Formula, we need to bring absences into the formula for union overtime calculations. I was able to retrieve the absence information, but for absences that span multiple days, the formula only returns the start date and the total duration (for example, 16, 24, or 32 hours). This has become an edge case for us. Is there a way to retrieve absences day‑by‑day instead of only getting the start date and total duration? Thanks for your support.