mm:ss time format overload

[rickboylan]

I have a cell (A1) formatted as time mm:ss. The formula in the cell i
A2 / 1440. The value in A2 is 1464. The formatted data in A1 show
0:24. The problem is that the time format for mm:ss has an upper limi
of 24 minutes. How do you set up the cell so it can show times of 2
minutes or more? By the way, the value 2879 will show 23:59

 

[Frank Kabel]

Hi
try formating the cell with
[mm]:ss

 

[rickboylan]

Thanks Frank,
From your response I realized I was using the first Excel Time forma
which shows up as 13:30. It was working as minutes and seconds but i
actually in the format of hh:mm. When I put the custom format [mm]:s
in as you suggested and divided by 86400 instead of 1440 the result
were correct.
Rick Boyla