IF function using TIME

[KarenM]

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!

 

[Gary''s Student]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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!

 

[FSt1]

hi
try this
=IF(B6="N/A",4,IF(A6="N/A",3,IF(B6-A6>0.041667,2,1)))

regards
FSt1

 

[KarenM]

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

 

[KarenM]

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