Any Cognos Experts?? HELP!!! Converting time from seconds to MM:SS to be used in time based calculations

Thanks for the response.  They are doing this in a crosstab, so will I be able to summarize a column where I have created a time interval using several data items (hours:minutes:seconds).  The reason I ask is there is an average and total time calculation that is done based on day and different levels of business unit.  I was thinking that since I have the total seconds as a measure in the cube I could just create column that does average and total time (in hours:min:sec) that would be calculated/recalculated at every level when drilling up or down this way I would not necessarily have to worry about doing an aggregation by summing the columns in the report (not sure if that makes sense).  The thing is that most of the reporting is done based on counts of thing like ON-TIME delivery, or delivery < 45 and < 60 which I can do pretty accureately just converting seconds to whole mintues comparing to either promised time or the other intervals (45 and 60) that they want statistics on.  The only thing is being able to add the MOD on for seconds can make a difference when doing these comparisons so if you know of a way to concatenate the minutes:seconds calculations together in way I can compare it with another column that is an integer that would probably give me the final piece I am missing.  Thanks again for the response on this the calculations you gave me were very helpful.  Any additional help on creating the hour:min:sec column I can use to compare with other time columns would be great.  Thanks.

I'm not clear on why you'd want to covert to hh:mm:ss for aggregation and comparison...why not just leave it as seconds?  You only need to convert to hh:mm:ss for display purposes, right?

Yes technically it is for display purposes and I will be doing aggregation using seconds only converting to HH:MM:SS for display purposes but I need to convert to MM:SS for some of the comparisons because for example if a delivery takes 45:33 and promised time was 45 it is still considered on-time because it was in 45 mintues (or < 46 minutes).  So I have had inconsistencies in the total counts and percentages when I just convert to whole minutes when the totals from my Report Studio reports are compared to the "traditional excel" reports they currently use.  And it comes down to the doing some of the comparisons using MM:SS.  However, I have found that if I use the conversion with MOD that I get the correct numbers for minutes and seconds but I just can't figure out how to display MM:SS using the results of the conversion calculations.  If I do minutes as an INT with a precision of 0 it will round up throwing off the mintues.  Is there a way to just take the numbers to the left of the decimal and then concatenate them with the results of the MOD calculation for seconds so you if I was to do something like TOTAL SECONDS = 934 I get minutes using TOTAL SECONDS / 60 = 15.567 and MOD(934,60) = 34 if I take the 15 and 34 I get the correct MM:SS value of 934 seconds --> 15:34.  However if I treat MINUTES as an INT precision 0 I get 15.567 rounded up to 16 and would still get the MOD = 34 for seconds which would give me the value of 16:34 a whole minute off which could be the difference between a transaction being considered on time or not.  This throws off my on time stats and calculations and could also throw off my total calculations as well.  Can you help me figure out how I can blend the results fo my Minutes calculation and Seconds calculation to get the correct value (15:34 using the example from above).  Does this example and the issues I am having make sense?  If I can do that then I should be able to use this to solve my problem doing some of the comparison calculations and with my display issues when I show the aggregate values at the different levels.  Thanks again.