Convert milliseconds to dd hh:mm:ss

Posted by

In Power Automate, you could use the div,mul,concat and mod functions to derive the hh:mm:ss format

Say e.g. the milliseconds value is 554666861

You get days by dividing your input by 3600000*24

SudeepGhatakNZ_0-1687480823118.png

Which is 554666861/(3600000*24) = 6.419755336 days = 6 days

You get the hours by multiplying the remainder with 24

Which is .419755336 * 24 = 10.07412806 hours = 10 hours

You get minutes by multiplying the remainder of the previous action by 60

 Which is .07412806* 60 = 4.4476836 minutes = 4 min

You get seconds by multiplying the remainder of the previous action by 60

 Which is .4476836 * 60 = 26.861016 seconds = 26 seconds

Leave a Reply

Your email address will not be published. Required fields are marked *