Formatting time - minutes and seconds NOT time of day

[RodneyW]

In cell E4 I have entered 4:44 intending it to mean 4 minutes and 44 seconds but Excel changes it to 4:44:00 AM. I have also entered it as 04:44 with the same result. Entering 00:04:44 changes it to 12:04:44 AM.

E5 will have 3:15

The goal is to have F5 add E4 (4:44) and E5 (3:15) giving me 7:59. From there the formula changes slightly.... F6 will add F5+E6. F7 will add F6 + E7 and so on. Ironically this formula works until the calculation in column F surpasses a total of 24 minutes because Excel thinks 24 minutes is 24 hours and reverts to a new "day".

I need the totals in column F to continue adding minutes until the total exceeds 59 minutes and 59 seconds at which time it would show 1:00:00 or whatever where the first number is hour(s), then minute(s) then second(s).

I've tried formatting the values in column E as [mm]:ss and that doesn't solve it.

Any ideas?

Thanks in advance.

 

[Cubist]

In cell E4 I have entered 4:44 intending it to mean 4 minutes and 44 seconds but Excel changes it to 4:44:00 AM. I have also entered it as 04:44 with the same result. Entering 00:04:44 changes it to 12:04:44 AM.

This is expected behaviour. Try changing the formatting to [h]:mm:ss

Book1
	E	F	G
7	0:04:44	0:03:15	0:07:59
Master

Cell Formulas
Range	Formula
G7	G7	=F7+E7

 

[RodneyW]

This is expected behaviour. Try changing the formatting to [h]:mm:ss

Book1
	E	F	G
7	0:04:44	0:03:15	0:07:59
Master

Cell Formulas
Range	Formula
G7	G7	=F7+E7

Thank you. That did it