Thread: Please help with enclosed schedule of duty
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Please help with enclosed schedule of duty

In G8 try this.

=IF(AND(G6="",G7=""),"",IF(G7<G6,G7+1-G6,G7-G6))

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=499703

Reply With QuoteReply With Quote