The bormula will be based on SUMPRODUCT, but you must upload a sample data to see the format used, especially for that military time, is it entered as text, or the column is formatted as date "hhmm" ?