Report time-pending request

Report time-pending request

Dear all

I has a report contains all uncomplete request (include Create time)
Now i want to count from Create time to when report created to makesure how long request pending.
In SD, just have field "Time Spent" count from Create Time to Close Time.
Any idea with that?

i use SD with MS SQL.
Thanks 

                  New to ADSelfService Plus?