Announcements
I am using a text label and in that text label I am using a formula which is converting numbers to hours and minutes.
And want to fill the color of text label according to hours number.
Like if text label is 8:00 then i want to fill label by green color.
@Leo_yz ,
What formula are you using to display the hours and minutes and what colour options do you want with the relevant times ?
I am using this formula:
With({inputMins:ThisItem.Mins},With({outputHrs:RoundDown(inputMins/60,0),outputMins:Mod((inputMins),60)},$"{outputHrs}{If(outputHrs>1 Or outputHrs<0 Or outputHrs=1 Or outputHrs=0,":")}{Text(outputMins,"00")}"))
and if outputhrs is 8 then fill RGBA(218, 254, 187, 1)
I assume you wrote that code ? If so, why the incredible over-complexity to simply turn minutes into hours and minutes display ? For the colour, all you really need to do is test Minutes/60 for the relevant hour.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
