| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to compare time cell to a time
Hi Friends,
Here's the equation that isn't working: =if(and(E5<$A$2,F5time(06:00:00),F5<=time(14:00:0 0)),"1st Shift",if(and(E5<$A$2,F5time(14:00:00)),"2nd Shift",if(and(E5=$A$2,F5<=time(06:00:00)),"2nd Shift","Do Not Count"))) I want it to exclude values prior to 6 AM yesterday and after 6 AM today. A2 is today. I want it to split the included values into 1st shift and 2nd shift. 1st shift if from 6:00 AM to 14:00 PM. 2nd Shift is from 14:01 to 6:00 AM today. Column F is formatted as "time" and looks like this "13:01:15." Help and Thanks! -- Z-Man |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
| compare time | Excel Discussion (Misc queries) | |||
| Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
| compare time in IF statement | Excel Worksheet Functions | |||
Threaded Mode
