Time difference between date taken and time values

[anmac1789]

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.

 

[anmac1789]

so is recognised as a date and can be formatted into any format

i suspect this is the issue
When I type 27/07/2022 04:51 into a cell, I only get that text,
you are entering a date format

27/07/2022 - but your excel system is expecting YYYY-MM-DD
and so it assumes its TEXT and NOT a number

like my system does when trying to enter MM/DD/YY
if i enter
10/19/22 - it right justifies and nolonger a real date BUT text - because excel is expecting a MONTH and 19 is NOT a month and so it must be a date
like if i wanted to enter 1st June 22
01/07/22
but if i entered it in that format assuming it should show 7th Jan - as a US date MM/DD
it will be seen as a date - BUT the wrong date

see this a lot with US systems outputing into excel - well a lot of dates are real - BUT wrong and others are TEXT
a couple of questions even yesterday on the forum because of that issue

so if its seen as text , as i showed
TEXTSPLIT works
BUT not when its entered and recognised as a date

I dont feel i have explained that well

that was a bit wordy and confusing not gonna lie lol

 

[etaf]

sorry about that