how do I write an IF/other statement to capture certain time data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data for start and end times on specific dates. The data in start
date/time is formatted as 10/01/2006 7:30, and in end date/time as 10/01/2006
15:30. When importing the data from another application into Excel, I only
want data returned from 7:30 to 15:30, but the application isn't doing that.
For example, it's pulling data such as 10/01/2006 16:00 for start time and
10/01/2006 18:00 for end time. Is there an IF statement (or other statement)
I can write in these cells to include only cases that start at and between
7:30 AM and end at and between 15:30 (3:30 PM)?
 
I've figured out the way to strip out the date, so there are just times
available. Now I'm just trying to figure out how to write the IF statement.
My thinking is that it should be: =IF(b9>=7:30,IF(c9<=15:30),"include")).
What do you think?
 
Back
Top