Hi all,
i'm having issues to get the following done: I have a Takt in SAP which we use to maintain an overview of the completed work. I copy thos lines into excel to make a transfer to our following shift. But I want some information out that copied line to be automaticlly put in the cell next to it.
E.g., this is the line I copy from SAP to EXCEL:
PRM1465 15_AB__MOVE SHOCK RECORDER TO PINTS_ 30.000 MIN
And now I want that the time we have to do this (30 MIN in this case), to be automaticlly put into in the cell right next to it. So you get something that looks like this:
PRM1465 15_AB__MOVE SHOCK RECORDER TO PINTS_ 30.000 MIN | 30 |
The tricky bit is that every procedure has another name, but the buildup is always the same (4 underscores, minutes written after the time, etc.), so only the time is a delta, but will always be displayed in minutes ( e.g. 5, 15, 30, 60, 120) with a max. of 3 digits.
Bookmarks