I currently have a large table of data that has a piece of equipment ID, the date it was sent in for maintenance, and the time between maintenance. My problem lies in the time between maintenance. What I want to do is if my equipment name is x11, then lookup the last time this machine was sent in and find the difference in time for each time it came in. I have attached an image for reference, if there is some formula to do this that I can drag through the column that would be awesome. The first date column is the turned in date and the second is supposed to be the last turned in date
Bookmarks