Shambhu

Shambhu

  • NA
  • 81
  • 38k

1. Calculation of Delay in a work using shif timing

Oct 16 2010 4:59 AM
Hi All,

I want to calculate delay time for any work/process. I have shifts timing table just like office timing and it may be 1st, 2nd, or 3rd shift in a day. In between the timing few minute breaks are there for lunch or tea break etc.

 

One work/Process may be finished within 1st shift or it may go to 2nd, 3rd shift also or work may go to next day any shift also. And I have  a standard time for the work/process to complete.

 

ShiftTime

ID

Shift

FromTime

ToTime

Descriptioin

1

1

05:55

07:55

10 mins tea break

2

1

08:05

09:55

30 min lunch break

3

1

10:25

12:30

10 min tea break

4

1

12:40

14:30

End of 1st Shift.

5

2

15:01

17:00

10 min tea break

6

2

17:10

19:30

30 min lunch break

7

2

20:00

21:50

10 min tea break

8

2

22:00

23:35

End of 2nd Shift.

 

 

StandaredTime

ID

Stage

StageName

StandardTime(MINUTE)

1

1

WELD

600

2

2

PAINT

800

3

1

ASSEMBLY

800

4

1

QC

200

 

So I have to calculate the delay time for one work/process.  

 

Case 1 - Support Today there are only two shift. Process1 got started on  2nd shift at 18:30 and StandardTime is  10 Hours to complete the process and suppose it got finished next day 1st shift. So. Calculation would be something like this.

 

23:35(End of 2nd shift of first day) – 18:30 (Process starting time) –00:30 mins (Lunch break) – 00:10 (mins tea break) = 4:25 mins. Job is done. Next 5:30 mins job will be done on next day 1st shift. Next day calculation would be the same like.

5:55 am + 5:35 (hr job remain)  + 30 min (lunch break)  + 10 min (tea break). So the work should be finished by 12:00 AM afternoon.  

 

And Holiday also I have to calculate. And I need to add to this holiday to calculate delay.

 

ID       NoOfShift      Date

1        2                  2009-01-01 00:00:00.000

2        1                  2009-01-02 00:00:00.000

3        2                  2009-01-03 00:00:00.000

4        0                  2009-01-04 00:00:00.000

5        2                  2009-01-05 00:00:00.000

6        1                  2009-01-06 00:00:00.000

Note : NoOfShift 0 means holiday for that day.


Regards,
Shambhu

Answers (1)