cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Sum hours in "##:##" format in a Collection Column

Hello, 


I'm having trouble here hope someone can assist. 

 

I'm trying to sum an hours column in a Collection. The Collection has a column (duration) with values such as "02:00" (two hours) and "05:30" (five hours, thirty minutes). I want to sum these columns.

 

I'm using a Textbox control with its Default property set to: 

Text(
    Sum(
        workSummary,
        duration),
    "[$-en-US]##:##"
)

I have no errors showing in the Text box, but no values appear when the collection is populated with hours. What am I missing here? 

 

Thanks

 

10 REPLIES 10
Highlighted

@v-xida-msft wow! I've been dissecting this code for a while on the whiteboard.... this is really smart stuff. Great work again! Wish I could double-Kudo!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,230)