Your data is a little tricky.
Your times in the first table include a date element - this is how we know the TimeCompleted (e.g. 04:31) is actually AFTER the Time Started(e.g. 20:00)
The ScheduleStartTime in the second table doesn't have a date element - so we need to add a date part to it... this is why I tried using 2+[@ScheduleStartTime] However, that logic isn't quite right. Looks like we need to determine when you consider a day starts - as you're not treating midnight as the start of a new day.
So - given the time ranges, I'm guessing we can assume 12:00 midday is a reasonable cutover. We can build this in to the formula, to give us:
That's pretty horrible!
Bookmarks