Thanks,

I was going bananas.

Regards,
John E. Golden

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
The problem is that Excel assumes that 23:50 is 23 hours and 50 minutes,
not 23 minutes and 50 seconds. You normally have to put the number in as
23:50.0 or as 0:23:50 to convince it that you mean minutes and seconds.
The cell format you choose for *displaying* the number doesn't help in the
interpretation when you are typing the number in.
--
David Biddulph

"John E. Golden" wrote in message
...
Hello,

I have been trying to format some cells so that I can insert a simple
elapsed time in minutes and seconds (like 24:35), but when I try to
format the cells, the formatting seems to have a mind of its own.

Help would be appreciated.

Regards,
John E. Golden