Date Time Format

02-04-2023 11:05 AM
New Contributor II

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




0 Kudos
1 Reply
MVP Esteemed Contributor

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?

Think Location
0 Kudos