Unanswered

Convert int compose to hh:mm:ss

(1) Share

Report

Posted on by P3tar94

Hi everyone,

I'm stuck on how to convert and int value to hh:mm:ss
The value that i extract from excel is in string format which i later convert to int in order to calculate avrage sum
The value represents time in miliseconds and i would like to convert those miliseconds (which are Int type) to hh:mm:ss
Just to let you know im building this flow in Power Automate Cloud version
Does anyone have an idea on how i could achive this?

example: value of compose is 6861 and it should be converted to 00:00:06

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

@P3tar94 ,

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

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

Verify here

Convert Milliseconds to Hours, Minutes and Seconds (daftlogic.com)

Was this reply helpful? Yes No
P3tar94 4 on at

Like (0)

Report

@SudeepGhatakNZ Thanks for repplying!
I ended up creating 3 different variables called Hours,Minutes,Seconds and as you can guess i devided the output to represent each of the variable
At the end i've created a new compose that will give an output for what i've needed
The expresion for the compose was:

concat(formatNumber(variables('Hours'), '00'), ':', formatNumber(variables('Minutes'), '00'), ':', formatNumber(variables('Seconds'), '00'))

I hope someone will find this helpful!

Was this reply helpful? Yes No