I’ve an issue. I need to calculate a column with the difference between two dates (duration) and it should be calculated in hours. The problem is because I have many cases where the duration is greater than 24h.
begin: 10/02/2019 10:00:00 (dd/MM/yyyy HH:mm:ss)
end: 15/02/2019 08:00:00 (dd/MM/yyyy HH:mm:ss)
duration: 118 hours.
Anybody has some ideas to help me?
Thanks in advance