web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Round Down function

Power Apps

Answered

Round Down function

(0) Share

Report

Report

Posted on by amyharkus86

726

I have a text input field that shows time in minutes via a sum total

Sum(DowntimeCollection, LineTotal)

I'd like to show it in hours and minutes

I have tried this but am getting a funny return, I think i can use a round down but i am not sure where to place it

Concatenate(Text( ((Value(TextInput30.Text)/60) )), " hours ", Text( Mod(Value(TextInput30.Text),60 )), " minutes " )

I get the below results from the above.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @amyharkus86,

Emm，I think you have referred to a wrong parameter:

RoundDown(TextInput30.Text/60,0)&":"&Text(Mod(TextInput30.Text,60),"00")

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
try this:

Concatenate(RoundDown(Value(TextInput30.Text)/60,0), " hours ", Text( Mod(Value(TextInput30.Text),60 )), " minutes " )

Was this reply helpful? Yes No

Join the conversation