software

In column J I have the following formula =IF(E7=quot;quot;;quot;quot;;J5 (E7-F7)/24) and
everything works fine, but my problem is that if a 0 is in column E then the
status days in column J start to go backwards what I need is to add the
deference between column D and F to Column J if there is a 0 in column E but
the old formula needs to work if there is a number like 2,5 hours added to
column E.

Does anyone have any ideas on this???D E F G H
I J

Est.ActualAFEStart 05-mar-0611:30Status
Hrs.HrsHrsDayFinishedDays
DateTime

18,025,526,1to18-mai-0607:3016,0
3,01,02,5to18-mai-0608:3015,9
3,03,00,0to18-mai-0611:3016,0
18,017,50,0fr19-mai-0605:0016,8
18,00,00,0fr19-mai-0623:0016,8
4,00,02,5lø20-mai-0603:0016,7
105,00,063,8on24-mai-0612:0014,0
8,00,02,5on24-mai-0620:0013,9
2,50,09,8on24-mai-0622:3013,5
5,00,03,7to25-mai-0603:3013,3
2,00,09,8to25-mai-0605:3012,9
2,00,02,5to25-mai-0607:3012,8
4,00,07,4to25-mai-0611:3012,5Try this:

=if(e7=0;j5 (d7-f7)/24;If(e7=quot;quot;;quot;quot;;j5 (e7-j7)/24))

HTH

quot;need help in Norwayquot; wrote:

gt; In column J I have the following formula =IF(E7=quot;quot;;quot;quot;;J5 (E7-F7)/24) and
gt; everything works fine, but my problem is that if a 0 is in column E then the
gt; status days in column J start to go backwards what I need is to add the
gt; deference between column D and F to Column J if there is a 0 in column E but
gt; the old formula needs to work if there is a number like 2,5 hours added to
gt; column E.
gt;
gt; Does anyone have any ideas on this???
gt;
gt;
gt; D E F G H
gt; I J
gt;
gt; Est.ActualAFEStart 05-mar-0611:30Status
gt; Hrs.HrsHrsDayFinishedDays
gt; DateTime
gt;
gt; 18,025,526,1to18-mai-0607:3016,0
gt; 3,01,02,5to18-mai-0608:3015,9
gt; 3,03,00,0to18-mai-0611:3016,0
gt; 18,017,50,0fr19-mai-0605:0016,8
gt; 18,00,00,0fr19-mai-0623:0016,8
gt; 4,00,02,5lø20-mai-0603:0016,7
gt; 105,00,063,8on24-mai-0612:0014,0
gt; 8,00,02,5on24-mai-0620:0013,9
gt; 2,50,09,8on24-mai-0622:3013,5
gt; 5,00,03,7to25-mai-0603:3013,3
gt; 2,00,09,8to25-mai-0605:3012,9
gt; 2,00,02,5to25-mai-0607:3012,8
gt; 4,00,07,4to25-mai-0611:3012,5
gt;

..... better still...

=IF(AND(ISNUMBER(E7),E7=0),J5 (D7-J7)/24,J5 (E7-F7)/24)

If e can never be blank then

=IF(E7=0,J5 (D7-J7)/24,J5 (E7-F7)/24)and there was a typo in my original ....

=if(e7=0;j5 (d7-f7)/24;If(e7=quot;quot;;quot;quot;;j5 (e7-f7)/24))

quot;need help in Norwayquot; wrote:

gt; In column J I have the following formula =IF(E7=quot;quot;;quot;quot;;J5 (E7-F7)/24) and
gt; everything works fine, but my problem is that if a 0 is in column E then the
gt; status days in column J start to go backwards what I need is to add the
gt; deference between column D and F to Column J if there is a 0 in column E but
gt; the old formula needs to work if there is a number like 2,5 hours added to
gt; column E.
gt;
gt; Does anyone have any ideas on this???
gt;
gt;
gt; D E F G H
gt; I J
gt;
gt; Est.ActualAFEStart 05-mar-0611:30Status
gt; Hrs.HrsHrsDayFinishedDays
gt; DateTime
gt;
gt; 18,025,526,1to18-mai-0607:3016,0
gt; 3,01,02,5to18-mai-0608:3015,9
gt; 3,03,00,0to18-mai-0611:3016,0
gt; 18,017,50,0fr19-mai-0605:0016,8
gt; 18,00,00,0fr19-mai-0623:0016,8
gt; 4,00,02,5lø20-mai-0603:0016,7
gt; 105,00,063,8on24-mai-0612:0014,0
gt; 8,00,02,5on24-mai-0620:0013,9
gt; 2,50,09,8on24-mai-0622:3013,5
gt; 5,00,03,7to25-mai-0603:3013,3
gt; 2,00,09,8to25-mai-0605:3012,9
gt; 2,00,02,5to25-mai-0607:3012,8
gt; 4,00,07,4to25-mai-0611:3012,5
gt;