| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I write an IF/other statement to cut off 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 | |||
| Pie PivotChart loses data label every time i swich page value | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
