Hi,
I would appreciate any help with this problem.
At our place, we make different products for a few days of a week (production time anywhere between 20 to 72 hours of production time). The data is in the attached zip folder. I need to know how much of a particular product is made in the first 24 hours of a given date and time.
For example: (small extract from data)
LastOfDateTime Product Amount 2/3/2015 17:58 A1 42978.13 2/3/2015 18:06 A1 3069.87 2/3/2015 19:07 A1 14843.00 2/3/2015 23:31 A1 60749.00 2/4/2015 00:49 A2 18207.76 2/4/2015 02:50 A2 31799.18 2/4/2015 04:05 A1 17280.00 2/4/2015 05:54 A3 24192.00 2/4/2015 17:58 A3 12087.04 2/4/2015 18:57 A3 13813.76 2/4/2015 20:50 A5 25888.00 2/4/2015 22:10 A2 16956.51 2/5/2015 01:02 A1 37760.00 2/5/2015 05:36 A2 72425.86 2/5/2015 05:58 A2 6396.72 2/5/2015 10:48 A2 73562.31 2/5/2015 14:00 A6 44493.32 2/9/2015 05:13 A1 45824.00 2/9/2015 05:58 A1 8853.90 2/9/2015 07:34 A1 20659.10 2/9/2015 12:33 A6 64309.97 2/9/2015 13:57 A6 18646.66 2/9/2015 17:59 A6 59414.32 2/9/2015 18:43 A6 7245.65 2/9/2015 20:16 A6 23673.32 2/10/2015 01:42 A2 74037.36 2/10/2015 05:58 A2 70492.17
From the above data, if I enter 02/10/15 01:00 then I would need sum of all Amount data for the 24 hours before it, by product, i.e., till 02/09/15 01:00; A1 = 75337.00; A6 = 173289.92
Please let me know if you have any questions.
Thank you for the help.