Help with Time Spent report (Crystal Reports)

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?