SQL Reporting Services Time issues

[mchambers]

I have a report that is suppose to total the time a service event has. For example:
Service provided = 60 minutes or 15 minutes. When I dump my data into sql it changes the datatype into and Integer. So my question is:

How do I format the field to Sum up the time correctly if it is reading as integer and not as time?

 

[jbenson001]

There is no time datatype in sql. You will have to do some simple math to get the correct value.

 

[mchambers]

Ok thanks for your response.

 

[jbenson001]

No problem.