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.
Solved! Go to Solution.
Hello @jajuele not clear with the question. Could you please clarify with an example?
Thanks,
Yug
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.
Can you please a sample formula solution in excel? also please share data for few more stations, that would help check if calculations work fine.
Regards,
Kaushik
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
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
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