I would like to know how to approach it. This could be an easy calculation.
This is for a trucking company and I want to calculate how many hours an asset has been idol. I have the dates an times of use for each asset on a tracking sheet. Each row contains a date when the load was picked up (along with a time) and a date/time it was delivered. I want another column to tell me how many hours have elapsed between the current "time in staging" from the last "time out of location".
I have attached a file with the column (Column "S") that I would like to populate itself
I suspect it will be a match and index formula
Any help is greatly appreciated.