Time Formatting Does Not Work for me
Did you try:
[hh]:mm
And did you enter the value as a real time: 24:35
When I entered 24:35 in a cell formatted as General, excel helped me by making
the format [h]:mm:ss
But that was kind of close to what you wanted.
"John E. Golden" wrote:
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
--
Dave Peterson
|