web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Convert decimal number...

Power Apps

Answered

Convert decimal number to hh:mm:ss

(0) Share

Report

Report

Posted on by HectorOlivos

411

Hello Community!

How can I convert a decimal value to Hours with minutes and seconds?

Example:

0.34949074 to 08:00:25

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

jadhav_ravi_oo7 276 on at

Like (1)

Report
Kindly Use Below Formula On - on text property
formula-
RoundDown( Mod(0.34949074*24*60,3600)/60,0) & ":" &Int(Mod(0.34949074+86400,60)) & ":" & RoundUp((0.34949074+86400)/3600,0)

Kindly Accept the Solution and Give Kudo

Thanks & Regards,
Ravindra Jadhav
Independent Consultant | Freelancer
+91-9146152149
Connect Me On Different Platforms
LinkedIn || YouTube ||Blogger ||

Was this reply helpful? Yes No
CarlosFigueira on at

Like (0)

Report
Is 0.34949074 supposed to be a fraction of a day? If that's the case, then you can use the formula below:

Text(Time(0, 0, 0.34949074 * 24 * 60 * 60), "hh:mm:ss")

Notice that it will not return 08:00:25 (that would be equivalent to something like 0.333622685, as 0.33333333 would be 08:00:00, and 25 seconds would add about 0.00028935 to that value), but it will return 08:23:15 instead.

Was this reply helpful? Yes No
HectorOlivos 411 on at

Like (0)

Report

Nop, it´s not a fraction of a day 🙂 it's the sum of time of machines that are not running.

This is the original values that I wanted to recreate from a QlikView Table
In qlikview i can convert that decimal with an interval function and it gives the 08:23:16

But i noticed is not matching in powerapps

Was this reply helpful? Yes No

Join the conversation