web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dynamically Get Minute...

Power Apps

Answered

Dynamically Get Minutes for Time()

(0) Share

Report

Report

Posted on by ctedesco3307

802

I have a whole number I want to convert to time - ex 570 How Do I use Time to dynamically get the minutes right

=570/60 = 9.5 Which = 9:30 AM

Time(570/60 ,0,0) makes 9:00 - I don't want to hard code Time(570/60 ,30,0) b/c the time could also be 45 minutes after the hour.....

How do I dynamically get the minutes right?

thx

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @ctedesco3307,

The following function should do the trick. Feel free to replace 570 with a variable in which you store the number to make it dynamic - I used 570 as a test:
With({minutes:570},Time(Int(minutes/60),Mod(minutes,60),0))

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
ctedesco3307 802 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM - perfect! Thank you!

Was this reply helpful? Yes No

Join the conversation