MT_Cybertyper wrote:
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)