The expressions work well, thanks for the info, but what about date and time from 2 fields? I am having issues getting the time differences not computing as negatives when they are past midnight, so I would need to use the date field to add 24 hours to the minutes past midnight, not sure how to pull it off.
I am using the interval function on the minutes cause I got time data for instance that says, Scheduled time, 2200 actual time, 2205 so what I did was, =sum(interval(Scheduled - Actual, 'hhmm') and it works, but when the clock goes over midnight the result is a big negative number. How do you suggest I solve this. Example that does not work, Scheduled time 2350, Actual time 0050. This gives me -23hours instead.