web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to add hours by co...

Power Apps

Answered

How to add hours by converting from numbers to hours

(0) Share

Report

Report

Posted on by Fioravanti

98

Good afternoon

I have a label that would add up to a value in hours within a gallery.

This label is adding, but it is showing the value in numerical hours and not in standard hh:mm hours.

I would like to add it up and turn it into hours HH:MM

I'm putting in the question the code I'm using

qtda horas.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 155,927 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Fioravanti ,

Firstly, please post your code also in Text - saves re-typing/OCR this end. Try this

With( { _Total: Sum( Gallery2.AllItems; ’Quantidade de horas’ ) }; With( { _Hours: RoundDown( _Total; 0 ) }; _Hours & ":" & Round( (_Total - _Hours) * 60; 0 ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Fioravanti 98 on at

Like
a
(0)

Report
Copy link

Link copied!

Very good. Thank you very much, it worked perfectly

Was this reply helpful? Yes No

Join the conversation