I was looking to set conditions, so if day of week is Monday, start time is >= 07:30 and end time is <= 19:30, then calculate the hours and put these into a 'Weekdays' column
Great. You know your sorting rules. So implement that.