I have many rows of data and several columns (maybe 10) of dates/ times written in a cell , also in military time, with this format
9/10/13T2300
10/1/14T215
etc
etc
Essentially I need to find the difference in time between two columns. For example:
Date/time A - Date/time B = amount of time
this could be days, hours, minutes, or etc
but i CAN'T FORMAT THE DATE/TIMES!!!!!
Bookmarks