Thread: If Statement to subtract €śtime€ť if condition met
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default If Statement to subtract "time" if condition met
You seem to have some unnecessary functions in there.
OR(AND(R14=""),AND(S14="")) is just
OR(R14="",S14="")
--
David Biddulph


"BumblebeeFan" wrote in message
...
Got it to work using:

=IF(OR(AND(R14=""),AND(S14="")),"",IF(AND(R14<=H14 ,S14=I14),(((S14-R14)*24)-J14),IF(OR(AND(R14=I14,S14=I14),AND(R14<=H14,S14 <=H14)),((S14-R14)*24))))

and setting format to [h].mm

Thanks for your time and help; looking at other posts and trying different
things finally worked.


Reply With QuoteReply With Quote