Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
i stuck a requirement that how to create a next row in new field.
requirement is below table
Date | Name | Shift in | Shift Out |
01-04-18 | A | 7:00:00 | 13:00:00 |
02-04-18 | A | 8:00:00 | 14:00:00 |
03-04-18 | A | 9:00:00 | 15:00:00 |
04-04-18 | A | 10:00:00 | 16:00:00 |
05-04-18 | A | 11:00:00 | 17:00:00 |
01-04-18 | B | 7:00:00 | 13:00:00 |
02-04-18 | B | 8:00:00 | 14:00:00 |
03-04-18 | B | 9:00:00 | 15:00:00 |
04-04-18 | B | 10:00:00 | 16:00:00 |
05-04-18 | B | 11:00:00 | 17:00:00 |
01-04-18 | C | 7:00:00 | 13:00:00 |
02-04-18 | C | 8:00:00 | 14:00:00 |
03-04-18 | C | 9:00:00 | 15:00:00 |
04-04-18 | C | 10:00:00 | 16:00:00 |
05-04-18 | C | 11:00:00 | 17:00:00 |
01-04-18 | D | 7:00:00 | 13:00:00 |
02-04-18 | D | 8:00:00 | 14:00:00 |
03-04-18 | D | 9:00:00 | 15:00:00 |
04-04-18 | D | 10:00:00 | 16:00:00 |
05-04-18 | D | 11:00:00 | 17:00:00 |
01-04-18 | E | 7:00:00 | 13:00:00 |
02-04-18 | E | 8:00:00 | 14:00:00 |
03-04-18 | E | 9:00:00 | 15:00:00 |
04-04-18 | E | 10:00:00 | 16:00:00 |
05-04-18 | E | 11:00:00 | 17:00:00 |
And Output is
Date | Name | Shift in | Shift Out | NEXT IN | NEXT OUT |
01-04-18 | A | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
02-04-18 | A | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
03-04-18 | A | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
04-04-18 | A | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
05-04-18 | A | 11:00:00 | 17:00:00 | ||
01-04-18 | B | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
02-04-18 | B | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
03-04-18 | B | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
04-04-18 | B | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
05-04-18 | B | 11:00:00 | 17:00:00 | ||
01-04-18 | C | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
02-04-18 | C | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
03-04-18 | C | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
04-04-18 | C | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
05-04-18 | C | 11:00:00 | 17:00:00 | ||
01-04-18 | D | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
02-04-18 | D | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
03-04-18 | D | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
04-04-18 | D | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
05-04-18 | D | 11:00:00 | 17:00:00 | ||
01-04-18 | E | 7:00:00 | 13:00:00 | 8:00:00 | 14:00:00 |
02-04-18 | E | 8:00:00 | 14:00:00 | 9:00:00 | 15:00:00 |
03-04-18 | E | 9:00:00 | 15:00:00 | 10:00:00 | 16:00:00 |
04-04-18 | E | 10:00:00 | 16:00:00 | 11:00:00 | 17:00:00 |
05-04-18 | E | 11:00:00 | 17:00:00 |
KINDLY TELL ME HOW TO USE PEEK WITH IF STATEMENT IN ABOVE REQUIREMENT
For This i am attaching excel file for row data in sheet 1
and
sheet 2 is result part
not working.i used this script