Hey guys, I need your help.
I got two types of ordernumbers which are sorted alphabetically (scroll down) and appropriate time stamps.
Now I want that to calculate the delta_time stamp as long as the ordernumber is the same.
The first delta_time stamp of each ordernumber type is 00:00:00. Then subtract the second time stamp from the first to get the second delta_time stamp.
I filled the first two delta_time cells so that you understand.
This is just an example. In reality I got more than 100 ordernumber types. So I need an automated solution.
Thank you for your help!
I got two types of ordernumbers which are sorted alphabetically (scroll down) and appropriate time stamps.
Now I want that to calculate the delta_time stamp as long as the ordernumber is the same.
The first delta_time stamp of each ordernumber type is 00:00:00. Then subtract the second time stamp from the first to get the second delta_time stamp.
I filled the first two delta_time cells so that you understand.
This is just an example. In reality I got more than 100 ordernumber types. So I need an automated solution.
Thank you for your help!
ordernumber | time | delta_time |
ZSC2JT2 VN | 07:03:00 | 00:00:00 |
ZSC2JT2 VN | 07:05:48 | 00:02:48 |
ZSC2JT2 VN | 07:07:29 | |
ZSC2JT2 VN | 07:09:07 | |
ZSC2JT2 VN | 07:10:34 | |
ZSC2JT2 VN | 07:11:59 | |
ZSC2JT2 VN | 07:14:38 | |
ZSC2JT2 VN | 07:16:46 | |
ZSC2JT2 VN | 07:18:14 | |
ZSC2JT2 VN | 07:19:46 | |
ZSC2JT2 VN | 07:21:35 | |
ZSC2JT2 VN | 07:23:05 | |
ZSC2JT2 VN | 07:24:27 | |
ZSC2JT2 VN | 07:25:35 | |
ZSC2JT2 VN | 07:27:41 | |
ZSC2JT2 VN | 07:29:06 | |
ZSC2JT2 VN | 07:48:27 | |
ZSC2JT2 VN | 07:49:45 | |
ZSC2JT2 VN | 07:51:09 | |
ZSC2JT2 VN | 07:52:30 | |
ZSC2JT2 VN | 07:54:38 | |
ZSC2JT2 VN | 07:56:22 | |
ZSC2JT2 VN | 07:57:47 | |
ZSC2JT2 VN | 07:58:59 | |
ZSC2JT2 VN | 08:00:24 | |
ZSC2JT2 VN | 08:01:39 | |
ZSC2JT2 VN | 08:02:51 | |
ZSC2JT2 VN | 08:05:28 | |
ZSC2JY6 VN | 06:32:04 | |
ZSC2JY6 VN | 06:33:31 | |
ZSC2JY6 VN | 06:34:44 | |
ZSC2JY6 VN | 06:36:02 | |
ZSC2JY6 VN | 06:37:23 | |
ZSC2JY6 VN | 06:39:28 | |
ZSC2JY6 VN | 06:40:41 | |
ZSC2JY6 VN | 06:41:54 | |
ZSC2JY6 VN | 06:43:17 | |
ZSC2JY6 VN | 06:50:56 | |
ZSC2JY6 VN | 06:52:10 | |
ZSC2JY6 VN | 06:53:24 | |
ZSC2JY6 VN | 06:54:37 | |
ZSC2JY6 VN | 06:55:49 | |
ZSC2JY6 VN | 06:57:02 | |
ZSC2JY6 VN | 06:58:16 | |
ZSC2JY6 VN | 07:04:07 | |
ZSC2JY6 VN | 07:05:26 | |
ZSC2JY6 VN | 07:06:40 | |
ZSC2JY6 VN | 07:07:53 | |
ZSC2JY6 VN | 07:09:06 | |
ZSC2JY6 VN | 07:13:29 | |
ZSC2JY6 VN | 07:15:45 | |
ZSC2JY6 VN | 07:16:56 | |
ZSC2JY6 VN | 07:18:14 | |
ZSC2JY6 VN | 07:19:25 | |
ZSC2JY6 VN | 07:20:41 | |
ZSC2JY6 VN | 07:22:06 |