I need to calculate the amount of missing Fraction for a certain date range(which I filter using a Multi Box). Normally every day should have a total of Fraction of 1, but there might be Time periods in which no activity was introduced. Now, I need a way to bring the following output:
Half Day(after 14)
Half Day(until 14)
Quarter Day4(from 16 to end of program)
Explanation: The Fraction of a single day should sum up to 1. If it doesn't, the rest of the day should be in the output table. Also if there is no data for a working day(case in point the date 23-04-18 doesn't have any data recorded), the Time Period should be "Whole Day" with Fraction of 1 in the output table.
Now the question is: How can I obtain the output table with the requested dates?