HH:MM:SS format for above 24 hrs in SSRS r2
HI,
i am working with Sqlserver 2008 r2 . i have a problem while showing the time format (HH:MM:SS).
currently i am using custom code to show above 24 hrs data in excel output as a string . but i need to show the data in Excel like " 48: 35:09" .after exporting to excel it should be in Time format not in string .
please provide me a better solution on this .
Thaya.S
Thaya.S
February 17th, 2011 3:46pm