| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I write an IF/other statement to capture certain time data?
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)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Capture | Excel Discussion (Misc queries) | |||
| how do I write an IF/other statement to cut off time data? | Excel Worksheet Functions | |||
| Hello I am trying to write an If/Then statement. Here is the data. | Excel Programming | |||
| capture date and data every time data changes | Excel Programming | |||
| Time Capture... | Excel Programming | |||
Threaded Mode
