SQL Server Reporting Services Format Hours as Hours:Minutes

Posted by Frank Schmitt on Stack Overflow See other posts from Stack Overflow or by Frank Schmitt
Published on 2010-05-21T19:20:36Z Indexed on 2010/05/21 19:40 UTC
Read the original article Hit count: 198

Filed under:
|
|

I'm writing reports on SQL Server Reporting Server that have a number of hours grouped by, say, user, and a total calculated based on the sum of the values.

Currently my query runs a stored proc that returns the hours as in HH:MM format, rather than decimal hours, as our users find that more intuitive. The problem occurs when I try and add up the column using an SSRS expression, because the SUM function isn't smart enough to handle adding up times in this format.

Is there any way to:

  1. Display a time interval (in minutes or hours) in HH:MM format while having it calculated in decimal form?
  2. Or split up and calculate the total of the HH:MM text values to arrive at a total as an expression?

I'd like to avoid having to write/run a second query just to get the total.

© Stack Overflow or respective owner

Related posts about ssrs-2008

Related posts about format