This sounds like it should be a no-brainer, but...that's what it is in my brain - a no!

I am summing numerous cells that are all SUMS of cells. All of the cells in question are formatted TIME>13:30.

This is the formula giving me trouble: =SUM(D14+D26+D42+D59+D72+D81)

My total is a funky number because it is greater than 24 hours. Currently my total is showing 04:11, but the last cell in the formula is larger than that. I have tried changing the formatting to HH:MM, but that doesn't seem to matter.

Hope I've been clear enough. Thanks for any assistance.

Pat