Microsoft Reporting Services — How to convert milliseconds to dd:mm:ss format

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.

%d bloggers like this: