excel on the run
New Member
- Joined
- Aug 7, 2013
- Messages
- 35
I need to subtract the "Actual Time,A4" from the "Time Remaining,C3" and if the "Actual Time,A4" is greater than
the "Planned Time,B4" I need to add that difference back on to the "Remaining Time,C3"
In the case below the answer would be "Time Remaining, C4" 3:15
Hope u can help, Thanking You ALL in advance
[TABLE="width: 386"]
<tbody>[TR]
[TD="class: xl63, align: center"][/TD]
[TD="class: xl63, width: 86, align: center"]A[/TD]
[TD="class: xl63, width: 78, align: center"]B[/TD]
[TD="class: xl63, width: 92, align: center"]C[/TD]
[TD="class: xl63, width: 65, align: center"]D[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]1[/TD]
[TD="class: xl63, colspan: 3, align: center"]Hours:Minutes 00:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]2[/TD]
[TD]Actual Time[/TD]
[TD]Planned Time[/TD]
[TD]Time Remaining[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]3[/TD]
[TD="class: xl63, align: center"][/TD]
[TD="class: xl63, align: center"][/TD]
[TD="class: xl64, align: center"]3:35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]4[/TD]
[TD="class: xl64, align: center"]0:50[/TD]
[TD="class: xl64, align: center"]0:35[/TD]
[TD="class: xl65, align: center"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
EOTR,
the "Planned Time,B4" I need to add that difference back on to the "Remaining Time,C3"
In the case below the answer would be "Time Remaining, C4" 3:15
Hope u can help, Thanking You ALL in advance
[TABLE="width: 386"]
<tbody>[TR]
[TD="class: xl63, align: center"][/TD]
[TD="class: xl63, width: 86, align: center"]A[/TD]
[TD="class: xl63, width: 78, align: center"]B[/TD]
[TD="class: xl63, width: 92, align: center"]C[/TD]
[TD="class: xl63, width: 65, align: center"]D[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]1[/TD]
[TD="class: xl63, colspan: 3, align: center"]Hours:Minutes 00:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]2[/TD]
[TD]Actual Time[/TD]
[TD]Planned Time[/TD]
[TD]Time Remaining[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]3[/TD]
[TD="class: xl63, align: center"][/TD]
[TD="class: xl63, align: center"][/TD]
[TD="class: xl64, align: center"]3:35[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]4[/TD]
[TD="class: xl64, align: center"]0:50[/TD]
[TD="class: xl64, align: center"]0:35[/TD]
[TD="class: xl65, align: center"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
EOTR,