convert timespentonreq field in SQL

convert timespentonreq field in SQL

I am trying to create some custom reports from our SQL database and I am have a problem convert the timespentonreq field. I can convert to time, but it drops the first digit of hours if more than 100 hours. Any ideas or help?

                  New to ADSelfService Plus?