Answered

Calculate Data from Collection/Dataverse

(0) Share

Report

Posted on by alt88

171

I have a collection (the collection is then patched into a dataverse table at the end via a button) that is filled through two input fields with times in the format hh:mm as text. In the input field A the time is entered at which I started to work and in the input field B the end time. The special is that you can make several entries on the same day. Means for example 8:00 to 10:00 and then a new entry from 11:00 to 12:00 and more. Input field A and B are stored in separate columns in the collection. Now I want that I get at the end of the day a total number of hours calculated. How do I do that?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

NZ0090 317 on at

Like (1)

Report
Copy link

Link copied!
@alt88 Do you have a column for date and EmployeeID? If you have a date column, you can filter your record by EmployeeID and today's date and then use the Sum and DateDiff function to get the total:
Sum( Filter(CollectionName, EmpID=0001 && Date=Today()), DateDiff(StartTime, EndTime, TimeUnit.Hours) )

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @alt88 ,

Please try:
Text(Sum(AddColumns(coltime,"totalHour",DateDiff(TimeValue(start),TimeValue(end),TimeUnit.Minutes)),totalHour)/60,"#.##")

Best Regards,
Dezhi

Was this reply helpful? Yes No