nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

49786_en-US

liliconcom

Finding Overlapping Time Ranges

Hi,

I have a table (attached) of clock in and clock out times for an operator doing different jobs. It is possible to clock on to multiple jobs – but their time will be split amongst all jobs worked in that time period.

I am looking for a JMP solution (either JSL or formula based) to look at the table and find overlapping time frames by operator and then divide their time by the number of jobs worked.

Thank you in advance for your help!!

Brian

Re: Finding Overlapping Time Ranges

@SirBWhite,
I think Tabulate might work . Please see attached a data table. You will see a green button called 'Trial' on the left . Right click and "Run".

Comments

There are no comments yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of