Hi! I am working with a daycare and have an excel sheet with attendance. I am trying to set up some sort of conditional formatting (not picky on the result) which indicates whether the child was present for a certain timeframe (meal time). I have been working with conditional formatting, and also with the logical IF statement, but cannot get the cell to either highlight or mark when the statement is true but NOT if false. This is what I am trying to accomplish:
If InTime < 8:00 AM and OutTime > 7:00 AM, then mark (highlight, X, whatever) the "Breakfast" column.
In other words, if they were there for at least 1 minute of the meal time (7-8AM), they are counted as being there for that meal. Can anyone help me?
Thanks,
Heather
Bookmarks