Duration between two times from different two table

[Muzekker_Vatan]

Hi,

Appreciate if you help me to have duration between two times from two different table columns.

table1 time1
table2 time2
Which formula ı need to have to have duration between these two tables?

Thanks in advance.

[dbaum]

{expression that returns time2} - {expression that returns time1}

Each portion of the expression depends entirely on the context where you need the result and, therefore, the context where the overall expression exists. For example, if you need the expression in a virtual column in table2 and table2 references table1, then you could use an expression along the lines of:

[time2] - [table2 column that references table1].[time1]