Expression for converting seconds to Hours and Minutes in SQL Reporting
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?
Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.