cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bradl
Frequent Visitor

Formatting Time and Decimal place

Hi,

 

I have been searching for help on a formatting problem i have but nothing seems to work.

 

as an example i have a 0.08333333 in this case was produced from 05

 

I am looking to display this in hours and minutes but i can seem to get the decimal places to round

I am using Round(Value(Label1.Text),0)&" Hrs "&(Value(Label1.Text)-Round(Value(Label1.Text),0))*60&" Mins"

Where label1.text is the 0.0833333 which has come from total hours in a gallery.

The problem is when when i go down to 5 minutes i get i get 4.999 minutes and not 5

 

 decimal.PNG

Many Thanks for you help

1 ACCEPTED SOLUTION

Accepted Solutions
bradl
Frequent Visitor

I have managed to figure this out by changing the formula to RoundDown(Value(Label1.Text),0)&" Hrs "&Round((Value(Label1.Text)-RoundDown(Value(Label1.Text),0))*60,0)&" Mins"

View solution in original post

2 REPLIES 2
bradl
Frequent Visitor

I have managed to figure this out by changing the formula to RoundDown(Value(Label1.Text),0)&" Hrs "&Round((Value(Label1.Text)-RoundDown(Value(Label1.Text),0))*60,0)&" Mins"

View solution in original post

v-siky-msft
Community Support
Community Support

deleted

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,470)