I am using CR9 and am calculating a turn around time and then diplaying it in Hrs & Mins.
Here is the formula:
datetimevar CDT:={View.CallbackDateODBC}+{View.CallbackTimeODBC};
datetimevar PDT:={View.PhoneDateODBC}+{View.PhoneTimeODBC};
numbervar callphone:= DateDiff ("n",CDT,PDT);
if callphone <=60 then totext(callphone) & "m"
else int(callphone/60) & "h" & "" & remainder(callphone,60) & "m"
This displays the results with 2 decimal places. Forgive my ignorance, but I can't figure out how to strip the deciamls and display the Hrs and Mins in whole numbers.
Thanks for any help.
Here is the formula:
datetimevar CDT:={View.CallbackDateODBC}+{View.CallbackTimeODBC};
datetimevar PDT:={View.PhoneDateODBC}+{View.PhoneTimeODBC};
numbervar callphone:= DateDiff ("n",CDT,PDT);
if callphone <=60 then totext(callphone) & "m"
else int(callphone/60) & "h" & "" & remainder(callphone,60) & "m"
This displays the results with 2 decimal places. Forgive my ignorance, but I can't figure out how to strip the deciamls and display the Hrs and Mins in whole numbers.
Thanks for any help.