madhatrs26
New Member
- Joined
- Apr 6, 2015
- Messages
- 7
I'm trying to find a solution to my issue. I have a set of data the first two numbers are current line production total and the second is the running total.
The second row has four times 8am, 10am, 1pm, and 3pm and below that are the target line totals per the times indicated above.
I'm looking to time stamp the first data source in row1 column A1 according to the first time in row2 A2 and compared to the line target to acquire a percentage?
Please help.
Thank you,
[TABLE="width: 256"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]541[/TD]
[TD]1,494[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]10[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD]600[/TD]
[TD]1000[/TD]
[TD]1600[/TD]
[/TR]
</tbody>[/TABLE]
The second row has four times 8am, 10am, 1pm, and 3pm and below that are the target line totals per the times indicated above.
I'm looking to time stamp the first data source in row1 column A1 according to the first time in row2 A2 and compared to the line target to acquire a percentage?
Please help.
Thank you,
[TABLE="width: 256"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]541[/TD]
[TD]1,494[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]10[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD]600[/TD]
[TD]1000[/TD]
[TD]1600[/TD]
[/TR]
</tbody>[/TABLE]
