Hello - I'm trying to add a column to a table that shows the duration of a meeting. I have column end_time and start_time and the table component pulls from a join query, combining many tables in my database. I have created a query that actually finds the difference between the two columns (start_time and end_time) but don't know how to connect it back to my join query. I'm attaching a screenshot of the join query and the datediff query. Would appreciate any support on this as I've been struggling for a while!
You could also simply add a custom column that looks at both start and end date/times and using moment() and .diff
https://momentjs.com/docs/#/displaying/difference/