I did end up going the route of the whole hours by extracting the HOUR() and MINUTE() from the Duration. Thank you.
Now that I was able to produce the correct data I am ready to sum it up. Now the issue that I am having is I am not able to filter the data.
- I have a Timesheet table that has the total hours of each WorkorderID.
- I have a Work Order action button that when you hit it creates a Work Order Report.
- I am trying to populate a field with the Total Hours of a project (WorkorderID)
The tally just ends up as zero when I try to specifically filter by WorkorderID
SELECT(Timesheet[Number Of Hours], ([_THISROW].[WorkorderID] = [WorkorderID]))
If I just use this then it pulls the Total Hours of every single entry in the Timesheet table.
Timesheet[Number Of Hours]
So basically when I filter it to just included the matching WorkorderID it fails.