I have a time field imported from excel that I want to add together to get a value. It is basically a call stats report. I am tying to add all the calls together and come back with a value in hours:Mins:Seconds
It is in this format in excel 12:04:15 AM. In excel sheet if I used to format :mm:ss I can add columns together.
Attached is the example. I am trying to add field Total Time. How can I do this in Qlikview ?