cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PedroFernandes
Helper II
Helper II

Convert hours to days and hours

Hi

I'm building a leave request app, and I want to convert a numerical value, corresponding to the number of workday hours, into a label showing how many days and hours the user has left.

 

In this case, each workday has 8 hours, so for example if the user has 165 hours left, I want that to translate to 20 days and 5 hours (although the operation 165 / 8 = 20.625 ends with a decimal).

Any suggestion on how can I convert this to days and hours remaining?

Much appreciated 

1 ACCEPTED SOLUTION

Accepted Solutions
Ramole
Super User
Super User

@PedroFernandes 

 

Check this post Convert decimals hours to hours and minutes 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

View solution in original post

3 REPLIES 3
Ramole
Super User
Super User

@PedroFernandes 

 

Check this post Convert decimals hours to hours and minutes 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

@Ramole 

Thank you for the link. I've read it and I think it might be the answer for my problem.

I'll re-read it and try to implement it tomorrow with a clear head (it's very late right now), and accept your answer as solution by then.

@PedroFernandes 

 

Your welcome

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,373)