I would like to calculate the time difference between an arrival time and a departure time. When the arrival time is before 00.00 and the departure time is after, the result get wrong for example 23 hours instead of 1 hour difference. (Ex: arrival 23.30, departure 00:30)
I have been trying to write the code like this;
this code give the result above.
I have also been trying to write something like;
IIF [arrivaltime] < 00:00 and [departuretime] > 00:00 then =SUM(24:00 - ([departuretime]-[arrivaltime])) else =SUM[departuretime]-[arrivaltime]
This syntax is wrong and I dont know how to write it the right way.
Greatful for help