Excel 2007. Using a sumif formulas. The formulas work until I get to a certain time for the "criteria" then all remaining times/criteria I need to be on the "criteria" cell then hit F2 and enter to get the formulas to calculate. Auto calc is activated. The cells are numeric in a HH:MM PM format...