Expressing difference of times in different formats

[anmac1789]

so, I've found files which are mismatched between date-taken and date-modified but I want to find the difference between these two dates in seconds or minutes or hours and/or a combination of either time formats. How can I find the difference between date-taken and date-modified in different formats ?

[void]

Please try FORMATDURATION()

For example:

addcolumn:a a:=FORMATDURATION($date-modified:-$date-taken:,"[hh]:mm:ss")



FORMATDURATION()
FORMATDURATION format syntax