Thread: Formula for adding military time?

Welcome to the forum. Use your existing formula and format the result as [h]:mm

I did that, but that's not always works correctly. Sometimes instead of adding, it subtracts time

Quote: Originally Posted by Pawko I did that, but that's not always works correctly. Sometimes instead of adding, it subtracts time Can you give an example? What result do you expect, what do you get?

Hello daddylonglegs. Thanks for trying to help me. My example is attached. Thank you again. Jan

Quote: Use your existing formula and format the result as [h]:mm Your cell is formatted at h:mm

Well, I do have them in that format, don't I?

Quote: Well, I do have them in that format, don't I? No, you don't. Select the cell, Format > Cells > Number, Custom, [h]:mm

I did that and doesn't work. Above you can find my example and try it yourself.

Sorry, but I've made a mistake, it's my fault. I followed your instruction but instead of using [h] I had just "h" and this obviously didn't work. After applying format like [h] it looks like it does work . Thank you so much for your help