IF function using TIME
 

I have a spreadsheet with: Column A showing Administration Time, Column B
showing Start Time.

I now need to create an "IF" function that can do the following:
If the total time difference between B and A (column B-Column A) is less
than or equal to 1 hour, then the true statement should be "1", if the time
is greater than 1 hour the result would be a 2, if Column A has text "n/a"
the result would be 3, and if Column B has the text "n/a" the result should
be 4.

I'm not sure how to do and IF command with so many options and that includes
time.

Thanks!

IF function using TIME
 

=IF(A1="n/a",3,IF(B1="n/a",4,IF(B1-A1<=1/24,1,2)))

--
Gary''s Student - gsnu200805

IF function using TIME
 

=IF(ISNA(A1),3,IF(ISNA(B1),4,IF(B1-A1<1/24,1,2)))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"KarenM" wrote in message ...
|I have a spreadsheet with: Column A showing Administration Time, Column B
| showing Start Time.
|
| I now need to create an "IF" function that can do the following:
| If the total time difference between B and A (column B-Column A) is less
| than or equal to 1 hour, then the true statement should be "1", if the time
| is greater than 1 hour the result would be a 2, if Column A has text "n/a"
| the result would be 3, and if Column B has the text "n/a" the result should
| be 4.
|
| I'm not sure how to do and IF command with so many options and that includes
| time.
|
| Thanks!

IF function using TIME
 

hi
try this
=IF(B6="N/A",4,IF(A6="N/A",3,IF(B6-A60.041667,2,1)))

regards
FSt1

"KarenM" wrote:

I have a spreadsheet with: Column A showing Administration Time, Column B
showing Start Time.

I now need to create an "IF" function that can do the following:
If the total time difference between B and A (column B-Column A) is less
than or equal to 1 hour, then the true statement should be "1", if the time
is greater than 1 hour the result would be a 2, if Column A has text "n/a"
the result would be 3, and if Column B has the text "n/a" the result should
be 4.

I'm not sure how to do and IF command with so many options and that includes
time.

Thanks!

IF function using TIME
 

Thanks so much, you have made my life so much easier!!!!!

IF function using TIME
 

Thanks, I have learned something new and I can actually use it for more
things I need to do with this spreadsheet.

"FSt1" wrote:

hi
try this
=IF(B6="N/A",4,IF(A6="N/A",3,IF(B6-A60.041667,2,1)))

regards
FSt1

"KarenM" wrote:

I have a spreadsheet with: Column A showing Administration Time, Column B
showing Start Time.

I now need to create an "IF" function that can do the following:
If the total time difference between B and A (column B-Column A) is less
than or equal to 1 hour, then the true statement should be "1", if the time
is greater than 1 hour the result would be a 2, if Column A has text "n/a"
the result would be 3, and if Column B has the text "n/a" the result should
be 4.

I'm not sure how to do and IF command with so many options and that includes
time.

Thanks!