Calculating hourly difference

[mmorala]

Hi,
I am trying to calculate the time between two fields in a ticket database, [RECEIVEDDATE] and [COMPLETEDDATE].

This is my formula:

Local DateTimeVar d1 := {TICKET.RECEIVEDDATE};
Local DateTimeVar d2 := {TICKET.COMPLETEDDATE};

DateDiff ("h", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday) -
DateDiff ("ww", d1, d2, crSunday)

Would this formula work? Is there another way I could do this that would be more efficient and accurate?

Thanks,
Michael

 

[mbarron]

It will work if you convert your weekends to hours. Currently they are days;

DateDiff ("h", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday)*24 -
DateDiff ("ww", d1, d2, crSunday)*24


Mike