I am trying to enter cell phone usage minutes:seconds in Excel 2003
therefore, the minutes can be 4 or 5 digits (i.e. 12345:03). I have used a
custom format of [m]:ss. I have found I must enter the information as
0:xxxxx:xx. It shows in the formula bar as a date and time but in the cell
itself as minutes:seconds (the "0" entered in the "hour" place never shows).
Here's the kicker. This only works have the time but there is no rhyme or
reason as to why it sometimes works and other times doesn't. I have asked
every "expert" in our IT department and even attended an advanced Excel class
to try to get an answer but no luck. Can anyone help!?
--
Diane
City of Lakeland
Lakeland, FL