Okay so this doesn’t address your actual problem but does illustrate how you could calculate with date and times exceeding date boundaries.
https://exceleratorbi.com.au/solving-a-complex-time-problem-in-power-bi/
I hope this is helpful