Time Help

[SFCChase]

I am trying to enter completion times into 7 cells. Those times will then be added together in an 8th cell for a total time elapsed. The issue I'm having is that every time i enter a time (mm:ss) it is converting to an AM/PM time. I have tried formatting to mm:ss, [m]:ss, and [mm]:ss and its still not working.

E1 - I enter 06:25 but it displays as either 25:00 or 385:00 depending which format I try. I want it to stay as 06:25

what am i missing?

 

[Peter_SSs]

Enter 0:06:25 with a format of mm:ss