Forum Discussion
Excel Formula - Date and Time
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 , if first time is always with Z (no time zone offset), conversion could be as
=SUBSTITUTE(LEFT(A1,LEN(A1)-1),"T"," ")+0
robin01 , to start new conversation is from here https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral
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!
