Thread: Calculate After hours
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Calculate After hours
Hi,

Am Tue, 1 Apr 2014 10:10:37 -0700 (PDT) schrieb :

Statement:
If working hours are past 6PM, then calculate after hours, if working hours are not past 6 pm do not calculate it.

try:
=IF(B10.75,B1-0.75,"")


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional
Reply With QuoteReply With Quote