web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Convert whole number t...

Power Apps

Unanswered

Convert whole number to hours and minutes

(1) Share

Report

Report

Posted on by insurin

46

I have an input box (TextBox1) that asks for an amount of minutes. From there I output to 3 labels

label1 = The original time from the input (TextBox1)

label2 = The original time plus 25% (TextBox1*1.25)

label3 = The original time plus 50% (TextBox1*1.5)

Example

Enter time in mins = 60

label1 = 60

label2 = 75

Label3 = 90

How can I change these labels so they show the outcome in hours and minutes. I want it to say

label1= 1 hour (or 60 mins)

label2= 1 hour 15 minutes

label3 = 1 hour 30 minutes

thanks all

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (2)

Report
Something like this:

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

Tested:

See if it works.

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (2)

Report
@insurin Thank you for accepting my solution. However I tested it again now, and my solution was not quite right, it will put a decimal in the hours if the number is say, 68. Instead use this tested formula. I also rewrote it to put repeated parts of the formula in a With clause for better maintainability. Check below:

With({_value:Value(Label1.Text),_num60:60},Concatenate(Text(RoundDown((_value/_num60),0)), " hours ", Text( Mod(_value,_num60 )), " minutes " ))

Check if above works better for you @insurin

In case you really don't like the With statement being there - here is the solution I originally gave but rewritten correctly if you want With not to be present in the solution for some reason:

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

I recommend the version I gave above that has the With statement in it though.

Check if it helps @insurin

Was this reply helpful? Yes No

Join the conversation