I need to count occurrences of a cell containing an appt time vs. blank.
Not all cells in the range contain a time, but I need to count how many appts occurred, thus having a time (ex. 2:00 PM) in any of the cells.
i tried
countif(A1:A25,"*:")
doesn't work
Any suggestions would be greatly appreciated.
Bookmarks