how do i add the times in a range of cells when some contain 00:00
format of cells to sum is hh:mm
format of cell with answer [h]:mm

it worked on one sheet when i tried to apply to another it gave the wrong answer