I have an MS SQL table. There are two columns I need to work on: HOURS_DURATION and MINUTES_DURATION. They are of INT type. As you may see in the photo I am attaching: TABLE SAMPLE IMAGE
Now, I am making a fast report. And for now I have a simple cast to varchar and addition of zero if a len(field)=1 and it looks like: 02:40, for instance.
The problem is I cannot make a SUM of these times...
Can you guys direct me and help me solve this?
Do I have to do this conversion in SQL select statement? or somewhere in the fast report?
Thank you in advance!