I have sheets that have a relation Stats and Trips. Each trip has a Start DateTime and End DateTime that then calculates the Duration. On each table i have a column that converts the Date Time to just month and year. The Stats table has a relation using the Month Year columns. I am using a rollup for a few of the other columns to calculate for example distance for each month. All is working fine.
The only issue I have is calculating the duration per month from the duration column on the trips table. The output values are not correct. I am guessing I need to convert the duration for each trip on the trips table and then roll that up and convert it back to duration on the stats table.
Can any one can point me in the right direction possibly with a formula to convert duration to decimal or some other solution?
Thank in advance.