Hi, I'm trying to do some quick schedule planning and wanting to return task according to time start and time end. So far I'm able to get it to return only if it >= the start time (in black text) but I'm not able to get it to return the rest (expected result is black text + green text).
In case that isn't possible, is there a way to instead use conditional formatting to highlight expected result cell? (black text + green text), any suggestion on the formula or similar post on auto populate schedule will be much appreciated.
Thank you
Here is the sample sheet
https://docs.google.com/spreadsheets...1QaRSUd8-bw8/e
Capture.PNG
Bookmarks