Calculating turaround time using IF function

[MT_Cybertyper]

I'm just learning to use the IF function, and it is not calculating
correctly, so am looking for help. I'm using Excel 2000.

For my spreadsheet, if a document is made available after 1700 hours
or before 0700 hours the following day, I want it to calculate the
turnaround time for those reports to begin at 0700 hours; otherwise
calculate the remainder of the reports from the time the report became
available to completion. Here's the IF statement I'm attempting to
use with little success.

E=Time report available
I=Finish time

=IF(OR(E>"17:00:00",E<"07:00:00),0700-I,I-E)

 

[Glenn]

I'm just learning to use the IF function, and it is not calculating
correctly, so am looking for help. I'm using Excel 2000.

For my spreadsheet, if a document is made available after 1700 hours
or before 0700 hours the following day, I want it to calculate the
turnaround time for those reports to begin at 0700 hours; otherwise
calculate the remainder of the reports from the time the report became
available to completion. Here's the IF statement I'm attempting to
use with little success.

E=Time report available
I=Finish time

=IF(OR(E>"17:00:00",E<"07:00:00),0700-I,I-E)

Copy your formula directly from the worksheet to the post if you want help. The
one you typed above is not valid.

Is it possible a report is made available before 17:00 but finished the next day?

You might be looking for something like this:

=IF(OR(E1>--"17:00:00",E1<--"07:00:00"),I1-"07:00:00",I1-E1)

 

[MT_Cybertyper]

Copy your formula directly from the worksheet to the post if you want help.  The
one you typed above is not valid.

Is it possible a report is made available before 17:00 but finished the next day?

You might be looking for something like this:

=IF(OR(E1>--"17:00:00",E1<--"07:00:00"),I1-"07:00:00",I1-E1)

Tried it out and yes, this works, except for those reports that are
available before 17:00. When this occurs, it would need calculated
from the time in that cell to 17:00 and then from 07:00 until
completion the next day. Not sure how to set this up.

Thanks for your help