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
Read more here: https://stackoverflow.com/questions/66337990/microsoft-reporting-services-how-to-convert-milliseconds-to-ddmmss-format
Content Attribution
This content was originally published by BigPaPa at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.