Jun 03 2019 02:15 AM
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).
Jun 03 2019 07:07 AM
@sam_joyce you are not going to be able to compare both fields as they are, you need to transform first one into a valid date/time format, maybe you can use string formulas to extract valid information into a new cell and then convert it into a date/time format
Jun 03 2019 07:40 AM
Jun 03 2019 07:43 AM
I can't see how to start a conversation in the website. Can you help?
I am trying to build extra spreadsheets off the master spreadsheet. So when I change a name on the master, it changes all the other spreadsheets.
Jun 03 2019 02:21 PM
@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
Jun 03 2019 02:22 PM
@robin01 , to start new conversation is from here https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral