How to format the duration in more than 24h

daniel.arruda · January 23, 2020, 2:15pm

Hello,
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.

Example:
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

michel.baldellon · January 23, 2020, 2:32pm

A simple formula (end-begin)*24 should be OK…

daniel.arruda · January 23, 2020, 2:48pm

Quite simple! I was looking for a different way to show this duration in terms of hours (more than 24), minutes and seconds but your suggestion is very simple and works as well.

Thanks a lot.