Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Times To Make Sure No Overlap
Ok€¦I have a question and dont have a clue how this could be done. Right now
I have a spreadsheet with Case Date, Case#, Room Code, Start Time, Stop Time. What I need excel to do is to 1) Make sure it is only comparing cases from the same room code and comparing them only to the same date. 2)Then I need excel to say compare the start time from row 2 to the stop time of row 1, and let me know if row 2 started before row 1 was finished. Right now I am doing a simple if statement. Does anyone know an easier way to do this? Let me know if you need to know anything else. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Times | Excel Discussion (Misc queries) | |||
Comparing Times | New Users to Excel | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
what should i use | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |