Substract Timestamps

Hi,

I’m trying to substract two timestamps to achieve the duration. So far the formula is the column with the start timestamp minus the ending timestamp of the process. I already set the column type to Duration but it says “Arithmetic expression ‘([TIMEDATE RECIBIDO]-[TIMEDATE RECIBIDO TRANSPORTADOR])’ has inputs of an invalid type ‘Unknown’”

Any thoughts? Thanks for the help!

@AlejandroCamacho
Set the expression like this:

([TIMEDATE RECIBIDO] - "000:00:00") - ([TIMEDATE RECIBIDO TRANSPORTADOR] - "000:00:00")

Hi Levent! Good to read from you again!

I tried your solution but it shows the same message:

I’m I missing something? Thanks again!

@AlejandroCamacho
Are those [TIMEDATE RECIBIDO] and [TIMEDATE RECIBIDO TRANSPORTADOR] columns DATETIME type?

Yep… that was it, so sorry to have missed that. Thank you so much!