• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Overlapping Total Live Duration Calculation (Excel Macro)

Z

Ziara

New Member
Hi,
am trying to calculate the total duration of Equipment Live Time. In the case of the Equipment has only one serves then there is no overlap between Live Time events. The issue with the orders that have Equipment with multiple services Each one can overlap with multiple other Time.

upload_2018-2-1_2-1-48.png

I need to calculate the total amount of time any each Equipment ID then retain the calculation in Eq. LIVE Time. I'm new in programming and I couldn't find a solution for that. Any support?
 

Attachments

Sorry did not notice "macro" request, when I opened it the first time.
Would the formulas do?
first one finds the maximum end date
Second one finds minimum start date of the equipment
third one is an if to calculate difference between both, except when max end date is 0, then I use today.
 

Attachments

I'm not sure I get your requirement.

Can you clearly indicate what columns are needed for calculation, and what units columns are in?

As well, manually create few samples of desired out put.
 
You must log in or register to reply here.
Back
Top