Need help urgently. . please help

[yathish]

Hi there

Please help me with a VBA code to get the below things from a machine log file,

Excel workbook is kept in the below path:-

https://www.dropbox.com/s/5truxr18mf...book.xlsx?dl=0

Info:-

1. One cycle means Time between Process start and Process end, Refer column C in the workbook.

2. Machine interruptions are captured in column E.

Requirement:-

1. Need to calculate Cycle time, i,e; Time difference between process start and process end for each cycle in the column C.
2. Need to calculate Time between Process start and 1st Interrupt* (* If there is any interruption in that cycle)
3. Need to calculate Time differences between the interrupts in a cycle* (* If there are more than one interruption in that cycle)

All calculated values should come in respective rows in column I.

Please help me as soon as possible.

Thanks,
Yathi

 

[vletm]

@yathish
Press [Start] to get ASAP Your urgent help ... or something like this

 

[Hui]

Yathish

Firstly, Welcome to the Chandoo.org Forums

Can I please suggest that you read the site rules at: http://forum.chandoo.org/forums/new-users-please-start-here.14/ New Users Please Read

Although your problem maybe and I am sure is Urgent for you, it isn't for anybody else.
All answers here are provided by people who volunteer there time.
As such a descriptive Post tile like: Cycle Time Calculations, may attract the attention of somebody with expertise or experience in that area.
Where as a Title of Urgent, means that we have to read the post to determine if I am interested?

You should also follow up on your posts
Vletm answer the post in about and hour and a half, yet 10 hours later you haven't responded, so I am not sure how urgent it was/is?

 

[yathish]

@yathish
Press [Start] to get ASAP Your urgent help ... or something like this

thanks a lot vletm. . .

 

[yathish]

Yathish

Firstly, Welcome to the Chandoo.org Forums

Can I please suggest that you read the site rules at: http://forum.chandoo.org/forums/new-users-please-start-here.14/ New Users Please Read

Although your problem maybe and I am sure is Urgent for you, it isn't for anybody else.
All answers here are provided by people who volunteer there time.
As such a descriptive Post tile like: Cycle Time Calculations, may attract the attention of somebody with expertise or experience in that area.
Where as a Title of Urgent, means that we have to read the post to determine if I am interested?

You should also follow up on your posts
Vletm answer the post in about and hour and a half, yet 10 hours later you haven't responded, so I am not sure how urgent it was/is?

hi hui, Mistake noted (regarding mentioning urgent). . it will not be repeated again. . thanks to the forum. . you guys are simply amazing. .i was away from my pc so not able to thank vletm, , , really thankfull to vletm. .