Quote:
Originally Posted by Catalin.B
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" ?
|
My apologies. The format is in just a custom number with 0000 in order to show the 0 before. The number is calculated in a different table with vertical lookup. The number appears exactly as written and formula isnumber for the military time format = true.