title: How can get a full subtraction of time of these two time values in SSRS?
body: <p>I currently have two time values in two separate expressions in SSRS which I would like to subtract one from the other to give me a sub total time. </p>
  
  <p>At present value 1 is of 163:02:38 and the expression is as follows:</p>
  
  <pre><code>=System.Math.Floor(Sum(Fields!Staffed_Time.Value) / 3600) &amp; ":" &amp; Microsoft.VisualBasic.Strings.Format(Microsoft.VisualBasic.DateAndTime.DateAdd("s", Sum(Fields!Staffed_Time.Value), "00:00"), "mm:ss")
  </code></pre>
  
  <p>While value 2 is of 5:12:46</p>
  
  <pre><code>=System.Math.Floor(Sum(Fields!Time_in_Default.Value) / 3600) &amp; ":" &amp; Microsoft.VisualBasic.Strings.Format(Microsoft.VisualBasic.DateAndTime.DateAdd("s", Sum(Fields!Time_in_Default.Value), "00:00"), "mm:ss")
  </code></pre>
  
  <p>Meaning that the sub total I desire would be 157:49:52</p>
  
  <p>Now when I use this expression </p>
  
  <pre><code>=(System.Math.Floor(Sum(Fields!Staffed_Time.Value) / 3600) - System.Math.Floor(Sum(Fields!Time_in_Default.Value) / 3600)) &amp; ":" &amp; Microsoft.VisualBasic.Strings.Format(Microsoft.VisualBasic.DateAndTime.DateAdd("s", Sum(Fields!Staffed_Time.Value), "00:00"), "mm:ss")
  </code></pre>
  
  <p>It only subtracts the hour values which in this case would remove 5 hours, therefore only leaving me with a sub total of 158:02:38</p>
  
  <p>Therefore how can I get the expression to also subtract the minutes and seconds to get the desired subtotal? </p>