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
<tbody>
</tbody>
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
A | B | C | D | |
1 | Hours:Minutes 00:00 | |||
2 | Actual Time | Planned Time | Time Remaining | |
3 | 3:35 | |||
4 | 0:50 | 0:35 | ||
5 |
<tbody>
</tbody>
EOTR,