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.

Screenshot 2024-10-28 115752.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Suggested answer

Meekou 200 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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,579 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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