Jump to content

Hi, I am trying to calculate the time difference between 2 rows of data based on a couple of IF scenarios

Paul Kelly 2

Recommended Posts

What I am trying to do is calculate each ResourceNumber from the Finish Time of 3000 Scheduled Downtime to the Start Time of 5000 Unscheduled Downtime

[unsch Maint] - Max([scheduled Maint]) OVER (Previous([scheduled Maint]))

I have tried a lot of different formulas with no success.

The attached spreadsheet has the formulas I use in Excel.

Any assistance appreciated


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...