Hi
I assume your data is in column A, just like your post shows.
I define the name Months as ={"January";"February";"March";"April";"May";"June";"July";"August";"September";"October";"November";"December"}
Columns B, C, D, E are (Year, Month, Day, Time) determined by the following formulas
Formula:
=MID(A2,FIND(", ",A2,10)+2,4)
=TEXT(MATCH(AGGREGATE(14,6,FIND(Months,A2),1),INDEX(FIND(Months,A2),,),0),"00")
=TEXT(MID(A2,FIND(", ",A2,1)-2,2)+0,"00")
=MID(RIGHT(A2,LEN(A2)-FIND("at ",A2,10)-2),1,5)&" " &RIGHT(A2,2)
The date-time can be achieved using
Formula:
=DATE(B2,C2,D2)+E2
Now you can operate with real data-time as I do in column G, in G2 with =F3-F2 and leave G3 empty.
To drag down the formula you must select G2:G3.
See the file for clarification
Bookmarks