I am trying to preform simple formulas that I frequently use (and by the way have had similar problems at times)which are Sumif and Countif formulas. For examples in column (A) are Stock tick trade times by the seconds over multiple days. It is in the simple time format 9:30:01, 9:30:02, 9:30:03...