Ok, so I’ve gotten as far as getting my duration for each operation I’m needing. Now, I’ve been wanting to filter the data in two columns (Repair Order and Operation) in my [Entries] table in order to sum the durations and be able to view the total time value in a separate table [Repair Order]. In order to filter and sum this data I used
=SUM(SELECT(Entries[Duration Value],AND([Repair Order]=[_THISROW].[Repair Order], [Operation]=[_THISROW].[Operation])))
I use smart sheet so I ran into the issue of not being able to sum a ‘Duration’ since it wasn’t a value/number. I referenced a Timesheet app that pointed me in the direction of creating an app formula via a virtual column to convert the time value into a decimal format. In order to convert this time value in the virtual column ‘Duration Value’ I used
This however, did not work and I am still unable to sum my durations for an ‘Operation’ from a specific ‘Repair Order’ and view that information in another table. I’ve given screen shots to detail it out a bit better as well. Any suggestions?