Excel Formula - Date and Time

Copper Contributor

Created Date is formatted as 'General'. Last Modified Date is formatted as 'Custom' (dd/mm/yyyy hh:mm)Created Date is formatted as 'General'. Last Modified Date is formatted as 'Custom' (dd/mm/yyyy hh:mm)

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).

5 Replies

@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

Thanks @CarlosCorral - appreciate your help!

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.

 

@sam_joyce 

@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