morpheusdreams
MIS
Firstly I am not sure if this is the right forum, apologies if it is not.
From tSQL dataset we have a value which comes out as a total number of seconds.
We need to display this as HH:mm. we thought we had it cracked when we found:
=Format(Timeserial(0,0,Fields!TotalTime),"HH:mm")
However this resets to 0 when the time goes over 24 hours. We have googled this to hell and back and have not come up with any answers, please help.
From tSQL dataset we have a value which comes out as a total number of seconds.
We need to display this as HH:mm. we thought we had it cracked when we found:
=Format(Timeserial(0,0,Fields!TotalTime),"HH:mm")
However this resets to 0 when the time goes over 24 hours. We have googled this to hell and back and have not come up with any answers, please help.