How to match dupes and calculate the difference of date modified?

[anmac1789]

hello everyone, I have yet another question lol

If I find 2 duplicate pics, and they differ by 1 or more seconds, how do I find the difference between them? for example,

pic 1.jpg date modified: Dec 25, 2023 @ 11:22:56 AM

pic 2.jpg date modified: Dec 25, 2023 @ 11:22:57 AM

difference is 1 second, and I want the difference to be put in a custom column for each of pic 1.jpg and pic 2.jpg so that I know they are linked. Is this possible ? maybe by matching with name and size and then calculating the difference ?

[void]

If you just want to compare the two files:

addcolumn:a a:=$dm:

This will show the raw filetime in column a.

Calculate the difference from these two values.
The result will be in 100-nanoseconds.



To find files modified in the same hour:
addcolumn:a a:=int($dm:/36000000000) dupe:a

Combine with name or size:

dupe:name;size;a

This might not work for you as 23:59 and 00:00 will not be consider duplicates (even though they may differ by less than a second)



Everything doesn't have a method to show the date modified difference between files.

[anmac1789]

If you just want to compare the two files:

addcolumn:a a:=$dm:

This will show the raw filetime in column a.

Calculate the difference from these two values.
The result will be in 100-nanoseconds.



To find files modified in the same hour:
addcolumn:a a:=int($dm:/36000000000) dupe:a

Combine with name or size:

dupe:name;size;a

This might not work for you as 23:59 and 00:00 will not be consider duplicates (even though they may differ by less than a second)



Everything doesn't have a method to show the date modified difference between files.

What about using regex to find difference between 2 files ? What if there's a way to set up a 'block of files' that are duplicates and then assign a difference pattern ? for example,

file1
file2
file3

find difference between 1,2 1,3 then 2,1 2,3 then 3,1 3,2 so that each file is differentiated between the other 2...this is a case for 3 dupes but what if there are greater than or equal to 2 dupes ?

Wondering if it could be done with excel

[void]

Everything currently doesn't a way to compare the date modified between two files.

[anmac1789]

Everything currently doesn't a way to compare the date modified between two files.

Alright, thank you void

[NotNull]

I want the difference to be put in a custom column for each of pic 1.jpg and pic 2.jpg so that I know they are linked.

@meteorquake had a clever idea to mark files that are linked. Maybe this method can work for you too.

Link

[anmac1789]

I want the difference to be put in a custom column for each of pic 1.jpg and pic 2.jpg so that I know they are linked.

@meteorquake had a clever idea to mark files that are linked. Maybe this method can work for you too.

Link

But this is for color filters by extension

[NotNull]

@meteorquake makes clever use of that mechanism to show the mnames of pictures that are more than <time interval> apart in a different color.

[anmac1789]

@meteorquake makes clever use of that mechanism to show the mnames of pictures that are more than <time interval> apart in a different color.

so you are saying that using file extensions is the only way ?

[NotNull]

No. Please read @meteorquake's post carefully (and take a close look at the screenshot).