SQL Reports and Formating times

• Potso

  SSChasing Mays

  Points: 657

  More actions

  June 10, 2009 at 1:39 pm

  #384751

  I need to know how to format time in SSRS 2005. I am subtracting two times from eachother

  (created date - delivered date)

  my results are showing more than just HH:MM:SS

  my results are looking something like this. I have tried to work with the formatting but it does not seem to work for some reason.

  01:59:35.0670000

  I really just want my time to show up as: 01:59:35

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  June 19, 2009 at 9:37 am

  #1012514

  In the textbox that you are displaying the results of the calculation, use the format property.

  Setting the format property to t should get you what you're looking for.

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]