Hi,
I need to sum up a column which holds hour values. The single values are always < 24 hours and are formated as time interval with the time unit 'Time'.
Summing up those values should e.g give a value of 28:00, but it is shown as 1 04:00.
Maybe it is really a question that is easy to answer but I can't find any way to display hours > 24:00 in the same format.
Thanks very much for every hint!
Mike
Time interval may not the best choice as Cognos will add days to the formatted data when more than 24 hours are used.
Why not sum them as integers and then use cast the total to a varchar and adding the :00 part to the string?
Thanks for your reply.
Thought that there would be a different way to solve this.
Thanks very much!