Running SQL 2005 Reporting Services. I have a field in my report that shows total seconds. I would like to show that value as hours and minutes (ie 3:05 for 3 hours 5 minutes). Right now I have this expression:
=(Fields!TIMEINSECONDS.Value)\60) \60 & ":" & (Fields!TIMEINSECONDS.Value)\60) \60) \60
But this shows as 3:5
Is there a better expression to accurately get what I want?