AnsweredAssumed Answered

How add hh:mm:ss to Dates Range

Question asked by Marcoaldama on Feb 12, 2018
Latest reply on Feb 13, 2018 by Marcoaldama

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

 Regards,

Marco Velazquez.

Outcomes