web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate how to change number t...

Power Automate

Answered

how to change number to time (hh:mm:ss) consider number value as seconds

(0) Share

Report

Report

Posted on by CU26090608-0

16

Hi every one,

I need some help,

how to change number to time (hh:mm:ss) consider number value as seconds.

i got data like number but it is seconds like(4, 60, 120) so i need to convert this in to time hh:mm:ss

Thanks,

Renjeesh.

Categories:

Power Automate Desktop

Screenshot 2024-1...

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Meekou 200 Moderator on at

Like (1)

Report
There are two options for you:

Try to use time function like below

addSeconds('1970-01-01', 97, 'HH:mm:ss')

Try to build the string by convert seconds to hh, mm and ss

concat(formatNumber(div(97, 3600), '00'), ':', formatNumber(mod(div(97, 60), 60), '00'),':', formatNumber(mod(97, 60), '00'))

Note, 97 is my test input, you can replace it with your own varaible.

Regards,

Meekou

Private Support

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

If you use Power Automate (cloud) flow in this process then do as @Meekou instructed. If you use only Power Automate Desktop then like this:

Doesn't really matter what date you put but in Add put your variable and Time unit in Seconds:

Convert datetime to text -action:

Result:

Was this reply helpful? Yes No
CU26090608-0 16 on at

Like (0)

Report

Meekou Thank you so much for the Answer and eetuRobo thank you so much for the Answer and clarification

Was this reply helpful? Yes No

Join the conversation