Hi, I need your help in this, I need to distribute the Total duration of work orders between start date and end date so I can calculate the Total Hrs/Day for ALL work-orders within a given month.

I managed to calculate the portion of duration that happened in the First Day of the Work Order using the below Table Calculation:

if(${max_mwo_task_end}< (add_days(1,${1st_day_date})),diff_minutes(${min_mwo_task_start},${max_mwo_task_end})/60,diff_minutes(${min_mwo_task_start},add_days(1,${1st_day_date}))/60)

And the portion of duration that took place in the Last Day of the Work Order like below:

coalesce(if(${last_day_date} = ${1st_day_date},0, (diff_minutes(${last_day_date},${max_mwo_task_end})/60)),24)

So , each day_of_month in between the Start and the End dates of the Work-orders shall have 24 hours.

I need to represent each day of the month with the Sum of duration within that day.