Hello, I am calculating the duration hours with the following formula:
int((${PGDHEnd} - ${PGDHStart}) div(1000*60)) div(60)
although it can give me a result like the one in the photo I wanted you to set an example 7:30 pm - 6:00 pm = 1:30 am just not and it is giving me the value that is in the photo 1.5 hours of duration thank you very much
The time duration is correct as per your screenshot. It should be 1.5 hours, rather than 1:30 AM. 1:30 AM is a time, not time interval.
Could you share more information on why you want the difference value as time rather than time difference?