Simple question: I want to put i

[gasca]

Simple question:

I want to put in Excel a time (not an hour). That is

33 minutes 20 secs. I don't care which format 33:20, 33.20, etc...

When i try to put time in any format excel changes automatically the format to what he thinks is ok, but never to mm:ss, he puts date etc..

Which format do I have to choose in Cell Properties?
Please try it before because Personalized mm:ss doesn't work.

Thanks in advance.

Gasca.

 

[koresnordic]

Try a custom format of [m]:ss But you still have to enter the hours as 0. So 33 mins 20 secs is entered as 0.33.20

Graham