Hi @SteveDK ,
Based on your screenshot of your SharePoint List, I created a same list as yours:
Here I use CheckIngTime instead of CheckTime because they are both calculated column and don’t have the value of second.
For your first issue, you can set the items property of gallery to:
Distinct(TimeTrack,Title)
And it will distinct the duplicated record and only show the Title once.
For your second issue and third issue, firstly, you should get two values: the amount of checked items and the total of checking time.
Add a label and set the Text property to:
Sum(
TimeTrack,
Value(
First(
Split(
CheckIngTime,
":"
)
).Result
) * 60 + Value(
Last(
Split(
CheckIngTime,
":"
)
).Result
)
)/ CountIf(TimeTrack,":"in CheckIngTime)
//This formula aims to get the average of checking time
Finally, we need to format the value of average to “mm:ss” and set the Text property to:
Concatenate(First(Split(Text(Sum(
TimeTrack,
Value(
First(
Split(
CheckIngTime,
":"
)
).Result
) * 60 + Value(
Last(
Split(
CheckIngTime,
":"
)
).Result
)
)/ CountIf(TimeTrack,":"in CheckIngTime)
),".").Result).Result,":",Text(Value(Last(Split(Text(Sum(
TimeTrack,
Value(
First(
Split(
CheckIngTime,
":"
)
).Result
) * 60 + Value(
Last(
Split(
CheckIngTime,
":"
)
).Result
)
)/ CountIf(TimeTrack,":"in CheckIngTime)
),".").Result).Result*6)))
Hope it helps!
Thanks,
Arrow
