AnsweredAssumed Answered

How add hh:mm:ss to Dates Range

Question asked by Marco Antonio Velazquez Aldama on Feb 12, 2018
Latest reply on Feb 13, 2018 by Marco Antonio Velazquez Aldama

hi everyone

Currently, I am working with a report in CABI 4.1, but my client needs to Add the days in which a ticket is open, including the hh:mm:ss, when a ticket is closed in less than a day

I added the following formula with Open Date and Resolve Date

=DaysBetween([Open Date];[Resolve Date])


but, the result is incomplet. and some of the results show me as "0"

Can you help me to complete my formula?
I will be very grateful


Marco Velazquez.