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 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!
