Expressing difference of times in different formats
-
anmac1789
- Posts: 745
- Joined: Mon Aug 24, 2020 1:16 pm
Expressing difference of times in different formats
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
- Developer
- Posts: 19872
- Joined: Fri Oct 16, 2009 11:31 pm
Re: Expressing difference of times in different formats
Please try FORMATDURATION()
For example:
addcolumn:a a:=FORMATDURATION($date-modified:-$date-taken:,"[hh]:mm:ss")
FORMATDURATION()
FORMATDURATION format syntax
For example:
addcolumn:a a:=FORMATDURATION($date-modified:-$date-taken:,"[hh]:mm:ss")
FORMATDURATION()
FORMATDURATION format syntax