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 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
9 | Name | Path | Size | Time Created | Time Modified | Time Accessed | time created difference | Time Modified difference | Time Accessed difference | ||
10 | file1 | path1 | 7158 | time 1 | time 1 | time 1 | diff 1 = (1-2) | diff 1 = (1-2) | diff 1 = (1-2) | ||
11 | file1 | path2 | 7158 | time 2 | time 2 | time 2 | diff 2 = (1-3) | diff 2 = (1-3) | diff 2 = (1-3) | ||
12 | file1 | path3 | 7158 | time 3 | time 3 | time 3 | diff 3 = (2-3) | diff 3 = (2-3) | diff 3 = (2-3) | ||
13 | |||||||||||
14 | Name | Path | Size | Time Created | Time Modified | Time Accessed | time created difference | Time Modified difference | Time Accessed difference | ||
15 | file1 | path1 | 7158 | time 1 | time 1 | time 1 | diff 1 = (1-2) | diff 1 = (1-2) | diff 1 = (1-2) | ||
16 | file1 | path2 | 7158 | time 2 | time 2 | time 2 | diff 2 = (1-3) | diff 2 = (1-3) | diff 2 = (1-3) | ||
17 | file1 | path3 | 7158 | time 3 | time 3 | time 3 | diff 3 = (1-4) | diff 3 = (1-4) | diff 3 = (1-4) | ||
18 | file1 | path4 | 7158 | time 4 | time 4 | time 4 | diff 4 = (2-3) | diff 4 = (2-3) | diff 4 = (2-3) | ||
19 | diff 5 = (2-4) | diff 5 = (2-4) | diff 5 = (2-4) | ||||||||
20 | diff 6 = (3-4) | diff 6 = (3-4) | diff 6 = (3-4) | ||||||||
21 | |||||||||||
22 | 5 duplicate file list | Time Created | Time Modified | Time Accessed | time created difference | Time Modified difference | Time Accessed difference | ||||
23 | file1 | path1 | 7158 | time 1 | time 1 | time 1 | diff 1 = (1-2) | diff 1 = (1-2) | diff 1 = (1-2) | ||
24 | file1 | pathaa | 7158 | time 2 | time 2 | time 2 | diff 2 = (1-3) | diff 2 = (1-3) | diff 2 = (1-3) | ||
25 | file1 | path3 | 7158 | time 3 | time 3 | time 3 | diff 3 = (1-4) | diff 3 = (1-4) | diff 3 = (1-4) | ||
26 | file1 | pathb2 | 7158 | time 4 | time 4 | time 4 | diff 4 = (1-5) | diff 4 = (1-5) | diff 4 = (1-5) | ||
27 | file1 | pathd2 | 7158 | time 5 | time 5 | time 5 | diff 5 = (2-3) | diff 5 = (2-3) | diff 5 = (2-3) | ||
28 | diff 6 = (2-4) | diff 6 = (2-4) | diff 6 = (2-4) | ||||||||
29 | diff 7 = (2-5) | diff 7 = (2-5) | diff 7 = (2-5) | ||||||||
30 | diff 8 = (3-4) | diff 8 = (3-4) | diff 8 = (3-4) | ||||||||
31 | diff 9 = (3-5) | diff 9 = (3-5) | diff 9 = (3-5) | ||||||||
32 | diff 10 = (4-5) | diff 10 = (4-5) | diff 10 = (4-5) | ||||||||
Sheet1 |