Power Platform Community Forum Thread Details

HI,

I have 2 decimal with value as LeaveRequestToday: 0.46 (46 minutes) and LeaveRequest: 14.41 (14 hours : 41 Minutes).

What i am trying to do is adding these two decimal and convert it to valid 24 hours format Time.

For example: (LeaveRequestToday + LeaveRequest) ( 0.46 + 14.41) = 14:87 then convert it to time hh:mm i.e. 15:27.

Any idea ? Thanks

Categories:

Building Power Apps

Hi @GTPowerapp

If you had stored it in ticks it would have been super super easy.

Either way, I would convert them both to minutes before you convert it to time. Then use the addMinutes function to convert to Date/Time, and you can ignore the Date Part completely

Then I would use something like another colleague did well

Power Automate: addMinutes Function - Manuel T. Gomes (manueltgomes.com)

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey