View Single Post
  #11   Report Post  
Old April 9th 15, 04:12 PM posted to microsoft.public.excel.worksheet.functions
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2015
Posts: 1
Default If statement to compare time cell to a time

On Tuesday, September 9, 2014 at 4:21:14 AM UTC-5, wrote:
I need to use IF command with Time like
If A1 is lens then 6:00 hours the B1 to print Half Day else Full day

kindly guide the solution

Hoping someone can help, I need a formula to look at a time date cell

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 ,"")