Forum Discussion
Excel Formula - Date and Time
Please could someone show me a way to find the difference between these two cells. I would then like to plot the output into a graph (with the rest of the data set).
sam_joyce , if first time is always with Z (no time zone offset), conversion could be as
=SUBSTITUTE(LEFT(A1,LEN(A1)-1),"T"," ")+0