if then statements

[blairkropp]

how do you do an if then statement in excel. I am trying to do if e19-d19 > 8 then = "oss" else if equals that amount. I am trying to subtract by using miliraty time. can you please help. thanks!

 

[Mark W.]

=IF(E19-D19>8,"oss",E19-D19)

Not really sure if I understand your request. What's in E19 and D19?

 

[Brian from Maui]

how do you do an if then statement in excel. I am trying to do if e19-d19 > 8 then = "oss" else if equals that amount. I am trying to subtract by using miliraty time. can you please help. thanks!

Excel store times as fractions of a day, so 8 hours is 1/3, so....

=IF(A2-A1 > 1/3,"oss","")

or

=IF(A2-A1>"8:00"+0,"oss","")

Yor're unclear as to what happens when the time is less than or equals

 

[blairkropp]

e19 and d19 were the example cell numbers.

 

[Mark W.]

e19 and d19 were the example cell numbers.

Right. But, what do they contain?

 

[blairkropp]

if it equals or less than then it needs to give me the difference

 

[blairkropp]

they contain times in military time

 

[blairkropp]

brian from maui...

that didn't seem to work!

 

[blairkropp]

i got it to work, but if im trying to subtract 07:00 from 18:00 (they are two separate days) i am unable to do that.
any suggestions?

 

[Brian from Maui]

i got it to work, but if im trying to subtract 07:00 from 18:00 (they are two separate days) i am unable to do that.
any suggestions?

=IF(A2-A1+(A2 < A1) > "8:00"+0,"OSS","")

ot

=IF(A2-A1+(A2 < A1) > 1/3,"OSS","")

again, you're unclear as to what happens if the time is less than or equal to 8 hours.