Hi all and thanks for your help in advance.
I am working on a dataset involving work orders. Each row represents a unique work order and in separate columns I have work order start date, work order start time, work order end date and work order end time. I was able to combine columns so now I have two columns (rather than four) which shows work order start date and time and work order end date and time.
My problem lies in that I am now trying to calculate the time it took complete each work order. So if a work order opened cell reads 1/1/1412:00am and the closed cell reads 1/2/1412:00am it will give me 24hrs. Is there a solution to this? I feel like I may not have needed to combine the date and time columns, but I am out of ideas at this point.
Again, any suggestions are appreciated. Thanks!
Bookmarks