Substract Timestamps

[AlejandroCamach]

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!

[LeventK · Accepted solution]

@AlejandroCamacho
Set the expression like this:

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

[AlejandroCamach]

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!

[LeventK]

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

[AlejandroCamach]

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