I have a milliseconds value in my database (105823 ms) that I want to convert to a dd:hh:mm:ss value. This is the closest I can get is using the following code.
=Format(DateAdd("s",Fields!TimeSinceLastReset.Value , "00:00:00"), "dd:hh:mm:ss")
This works as long as it is less than 24 hours if over the dd is off, it is using 12 hour instead of 24 hour.
My result is 02:05:23:43. I do not really need the seconds just the hh:mm would be fine. the hours can be over 24. Thanks