Thread: If Statement to subtract €śtime€ť if condition met
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BumblebeeFan BumblebeeFan is offline
external usenet poster
  
Posts: 7
Default If Statement to subtract €śtime€ť if condition met
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