I have a question regarding using textsplit, match and exact functions. So, Im trying to find the time difference in seconds from the time portion of date taken and the time created, time modified and time accessed. I've tried using match, exact but somehow it doesn't seem to work. Please check my code. Thank you.
time.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Name | Size | Day Created | Day Modified | Day Accessed | Time Created | Time Modified | Time Accessed | Date Created | Date Modified | Date Accessed | Date Taken | ||
2 | 20220727_165105.jpg | 6734307 | 27 Jul 22 | 27 Jul 22 | 27 Jul 22 | 16:51:05 | 16:51:06 | 16:51:06 | 2022-07-27 16:51:05 | 2022-07-27 16:51:06 | 2022-07-27 16:51:06 | 2022-07-27 16:51:05 | ||
3 | 20220727_165105.jpg | 6734307 | 27 Jul 22 | 27 Jul 22 | 27 Jul 22 | 16:51:05 | 16:51:05 | 16:51:05 | 2022-07-27 16:51:05 | 2022-07-27 16:51:05 | 2022-07-27 16:51:05 | 2022-07-27 16:51:05 | ||
4 | ||||||||||||||
5 | =TEXTSPLIT(L2," ") | |||||||||||||
6 | 2022-07-27 | 16:51:05 | 01 | |||||||||||
7 | ||||||||||||||
8 | =EXACT(B6,B6) | |||||||||||||
9 | TRUE | |||||||||||||
10 | ||||||||||||||
11 | =MATCH($G2,$G$2:$G$3,0) | |||||||||||||
12 | 1 | |||||||||||||
13 | 2 | |||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A6:B6 | A6 | =TEXTSPLIT(L2," ") |
E6 | E6 | =TEXT(G2-F2,"[ss]") |
A9 | A9 | =EXACT(B6,B6) |
A12:A13 | A12 | =MATCH($G2,$G$2:$G$3,0) |
Dynamic array formulas. |