Announcements
Hello Community!
How can I convert a decimal value to Hours with minutes and seconds?
Example:
0.34949074 to 08:00:25
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 ||
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 413
WarrenBelz 355 Most Valuable Professional
timl 315 Super User 2026 Season 1
