Calculating number of days from 2 date/time (mm/dd/yy hhmm format)

[jandtng]

The data I pulled comes out as " 06/10/24 1315 " format. (military time)
I'm able to calculate the number of days between 2 dates and time when the time has a colon, but I can't figure out how to calculate this without a colon.

 

[arun_eagertolearn]

Assuming the entry is in A1

Case 1:
If this is formatted as text, you may use DATE(2000+mid(A1,7,2)*1, mid(A1,4,2)*1, left(A1,2)*1) to convert it into a date

The format is date(year,month,date)-
The above is assuming a DD/MM/YY format
In case it is MM/DD/YY, please swap the month/date portions within the DATE formula

Case 2:
If this already is a number, please use INT (A1)

Please do the same for the other entry where you need to do the conversion

A simple subtraction between the two will yield the result

 

[Cubist]

You can try inserting a colon and covert it to numeric type.

Book1
	A	B
23	06/10/24 1315	06/10/24 13:15
Sheet5

Cell Formulas
Range	Formula
B23	B23	=--REPLACE(A23,LEN(A23)-1,0,":")