SSRS export into excel as Time formatHi All,
I want to show seconds into format (HH:MM:SS) and value should work as time duration in excel export.
I am getting input as seconds (for example 93600 seconds),
and i need to show the seconds into HH:MM:SS format.
Am succeeded to show time(HH:MM:SS) in text format. But the problem which i am facing after excel export. We cannot able to sum up multiple cells, as it is string.
The output which i need is :00:00.
other example of output are :34:56, :55:45
Thanks in Advance.