I am trying to find the difference in hours between to date/times in the format of [m/d/yyyy h:mm AM/PM]. I tried to subtract the 2 in a column and it seems it ignores the dates and only subtracts the times. I know that some of my results in the 'cycle time' column should exceed 24 hours, but it won't capture for some reason.
screenshot.PNG
Any help with formulas or functions that I could use would be greatly appreciated!
Bookmarks