Periods define by start and end date

Hey guys,

do you know how I could first define a period with one start date and one end date ( both in yyyy-mm-dd , hh:mm:ss).

The next Problem is that i have to calculate accordances of three or more periods as an percentage. Do you know how to do this ?

Hope you can help me and staysafe.

Date Time

Accepted answers

RolandSchubert

Hi @jajuele ,

I've added some checks to ensure, that only overlapping periods are considered. Check it out, hopefully it works now as expected.

Best,

Roland

PeriodsShare.yxmd

All comments

ydmuley

Hello @jajuele not clear with the question. Could you please clarify with an example?

Thanks,

Yug

jajuele

Hello @ydmuley,

I`ve got an Station A: it has 6 different Dates 1. Start of door open 2. End of door open 3. sign in ( allowed to do work) start 4. sign out (allowed to do work) end 5. Station doesnt work start 6. Station doesnt work end . Now I want to create a period from start / end of door open. Same method for sign in/ out and Station doesnt works start/end .

In the End i Want to divide the period of door open by the period of sign in and divide the period of sign in by the period of Station off. That are Kinds of Service Quality indicators.

I´ ve attached an example. Same Things I want to repeat for other stations.

Example.xlsx

RolandSchubert

i @jajuele ,

I'm not sure, if I completely understood the problem. In my understanding, you want to calculate the share of one period (e.g. "Sign in") in another period (e.g. "Door open"). I've attached a sample workflow calculating length of periods and shares - what do you think?

Best,

Roland

PeriodsShare.yxmd

jajuele

Hi @RolandSchubert , thanks for your answer 🙂

generally thats my Idea, but theres one Problem: there are a few Examples where the Timelines dont cut each other. For example: (sign in start 14:00:00, sign in end 14:30:00) and (Station off start 14:40:00 ,Station off end 15:10:00). With your calculations it should be 1. But I want the overlapping of the periods. That means in this Example there is no overlapping of those timelines.

I`ve attached an example: I want to get the cutting period of those incidents to calculate the percentage (sign in to door open). I want the percentage of the sign in covers the door open.

Hope you understand.

Best

Jan

Example Time.png

RolandSchubert

Hi @jajuele ,

I've added some checks to ensure, that only overlapping periods are considered. Check it out, hopefully it works now as expected.

Best,

Roland

PeriodsShare.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703