Share
Report
29Hello,
I am building an app to record time. There is a field for "Project", "Start", and "End".
I have created a gallery to group all items where the project is the same (that match a date picker):
GroupBy(Filter('Time Recording', Start >= dprDateFrom.SelectedDate && Start <= dprDateFrom.SelectedDate + 7), "Project", "grpProject")
I then need to show the number of hours recorded for each day for each project:
I assumed that I would use DateDiff for the "Start" and "End" fields and possibly Sum them, but that doesn't work (I tried this "Text(Sum(ThisItem.'Work Order', DateDiff(Start, End, Hours)), "[$-en-US]hh:mm:ss")").
Any suggestions would be greatly appreciated.
Thanks!
Ryan
Categories:
I have the same question (0)
All responses (
Answers (
