I would like to get time differences.
Say I have 4 columns: Start day, start time, end day, end time. I would like to get the difference of the start day and time with the end day and time.
Problem is, times may be 20:00 on T, and 02:00 on T+1 , giving me a difference of 18 hours. When it should be 4 hours.
I need some help calculating the true time difference.
Any help would be greatly appreciated.