What I am looking at doing is displaying the length a call spent as open in one of my reports. But need the time displayed to be of a more meaningful format.
As an example, here is the create date of a call
and here is the resolved date
The formula I have been using is
{HPD_HelpDesk.Status_History_Resolved_TIME}-{HPD_HelpDesk.Create_Time}
this produces an open time of
So I can presume the call has been open for 14 days (can't work out the 78). So how can I show the time as 14 days x hours x minutes?
IP Logged
