Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date / time format - and nested formulas selecting from a range
I am trying to identify compliance with a shuttle departure based on peak
time criteria, or non peak time criteria. My worksheet data is copied from an online gps report, which has the cell for departures and arrivals as a date time format. Identifying the time between departures is a simple subtraction formula. When all relevant columns are simply time with no date, this formula works: I have 2 peak times and non peak times identified in the top of the sheet, and an end time for the shuttle. =IF(E18=npk, IF(E18=peakaft, IF(E18=nonpeakeve, IF(E18=$F$12,"No Shuttle","NonPeak"),"Peak"),"Non Peak"),"Peak") I either need to convert the column with the date time data to just time (it doesn't work with formatting the cell, I would need to trim the cells--- ) -- I tried Mod(a1,1) which strictly shows the time, but the date data is still buried, making the above formula useless... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting date range for counts | Excel Worksheet Functions | |||
selecting the first date in a range of dates | Excel Worksheet Functions | |||
USING THE NESTED IF FUNCTION TO SEE IF A TIME DATE VALUE IS T OR F | Excel Discussion (Misc queries) | |||
Selecting data within a date range | Excel Worksheet Functions | |||
Help! Selecting data according to date range | Excel Discussion (Misc queries) |