Summing Formulas of Time and Result is Greater than 24 Hours

[PatP3005]

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

[dilipandey]

HI Pat,

Welcome to the forum.

Try changing the format to [h]:mm .. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[PatP3005]

Thanks so much for your help DILIPandey! I knew it would be something simple. Simple if you knew it! I appreciate the assist.

[dilipandey]

You are welcome Pat..

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>