View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default If statement to compare time cell to a time

Hi,

Am Thu, 9 Apr 2015 08:12:53 -0700 (PDT) schrieb :

3/17/2015 11:57:30 AM

I need cells that contain a time between 12:00:00 and 12:00:59 to then print a number that is in the cell next to it(cell C). If it does not contain a time between this time, to just leave Blank
=IF(AND(B911TIME(12,0,0),B911<TIME(12,0,59)),C911 ,"")


try:
=IF(AND(MOD(A1,1)=0.5,MOD(A1,1)<=0.54097222),C1," ")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional