Help with Time Spent report (Crystal Reports)
I am currently using Crystal Reports to build a time spent report, but I am having major difficulty converting the value in the MM2COMPLETEREQUEST field into usable data.
I created the following formula for converting the info into hours:
Round(({RequestCharges.MM2COMPLETEREQUEST}/1000)/3600)
and the following for minutes:
(({RequestCharges.MM2COMPLETEREQUEST}/1000) - (Round(({RequestCharges.MM2COMPLETEREQUEST}/1000)/3600)*3600))/60
but neither seem to work consistently. I also tried the following for minutes based on info I found on the board:
Round(((({RequestCharges.MM2COMPLETEREQUEST}/1000)/60)) %60)
but that doesn't seem to work either.
Does anyone have any suggestions for me?
Thanks!
New to ADSelfService Plus?