Thread
:
If statement to compare time cell to a time
View Single Post
#
12
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch