Recursive Time difference for blocks of filename and size (duplicates)

anmac1789

New Member
Joined
Dec 6, 2020
Messages
43
Office Version
  1. 365
Platform
  1. Windows
hey guys! it's me again back with another question regarding excel functions. This time I have a request for a function that seems a bit...involved. How can I create a list like the below one ? For the difference in time, I am using a formula such as =text(abs(time1-time2),"hh:mm:ss") but again, I'd like to do this for every row or 'block' that has a matching filename and size. How do I do that ?

Book1
ABCDEFGHI
9NamePathSizeTime CreatedTime ModifiedTime Accessedtime created differenceTime Modified differenceTime Accessed difference
10file1path17158time 1time 1time 1diff 1 = (1-2)diff 1 = (1-2)diff 1 = (1-2)
11file1path27158time 2time 2time 2diff 2 = (1-3)diff 2 = (1-3)diff 2 = (1-3)
12file1path37158time 3time 3time 3diff 3 = (2-3)diff 3 = (2-3)diff 3 = (2-3)
13
14NamePathSizeTime CreatedTime ModifiedTime Accessedtime created differenceTime Modified differenceTime Accessed difference
15file1path17158time 1time 1time 1diff 1 = (1-2)diff 1 = (1-2)diff 1 = (1-2)
16file1path27158time 2time 2time 2diff 2 = (1-3)diff 2 = (1-3)diff 2 = (1-3)
17file1path37158time 3time 3time 3diff 3 = (1-4)diff 3 = (1-4)diff 3 = (1-4)
18file1path47158time 4time 4time 4diff 4 = (2-3)diff 4 = (2-3)diff 4 = (2-3)
19diff 5 = (2-4)diff 5 = (2-4)diff 5 = (2-4)
20diff 6 = (3-4)diff 6 = (3-4)diff 6 = (3-4)
21
225 duplicate file listTime CreatedTime ModifiedTime Accessedtime created differenceTime Modified differenceTime Accessed difference
23file1path17158time 1time 1time 1diff 1 = (1-2)diff 1 = (1-2)diff 1 = (1-2)
24file1pathaa7158time 2time 2time 2diff 2 = (1-3)diff 2 = (1-3)diff 2 = (1-3)
25file1path37158time 3time 3time 3diff 3 = (1-4)diff 3 = (1-4)diff 3 = (1-4)
26file1pathb27158time 4time 4time 4diff 4 = (1-5)diff 4 = (1-5)diff 4 = (1-5)
27file1pathd27158time 5time 5time 5diff 5 = (2-3)diff 5 = (2-3)diff 5 = (2-3)
28diff 6 = (2-4)diff 6 = (2-4)diff 6 = (2-4)
29diff 7 = (2-5)diff 7 = (2-5)diff 7 = (2-5)
30diff 8 = (3-4)diff 8 = (3-4)diff 8 = (3-4)
31diff 9 = (3-5)diff 9 = (3-5)diff 9 = (3-5)
32diff 10 = (4-5)diff 10 = (4-5)diff 10 = (4-5)
Sheet1
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,215,267
Messages
6,123,964
Members
449,137
Latest member
yeti1016

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top