1. Is C7:Z7 populated by a formula, manually, vba or otherwise?
1a. If a formula what is the formula?
2. If cells in C7:Z7 do not contain a time, what do they contain? (eg Text, blank, numbers etc)
Edit: I think I misread the first post. You said "looking for text in a time format", so doesn't a COUNTIF formula like post 2 (with the correct target range) do what you want?