What you could do is format your trip date (either with the ‘format date’ column, or the ‘math’ column) so that you remove the hours.
Then you create a relation columns between the formated trips’ date, and make it multiple. You can then use a rollup column to sum the trip’s distances from this relation.
1 Like