1440:00 is 24 hours, which is what you get from a number of 1 in the cell,
so it sounds as if you divided the content of the cell by itself.
Put 60 in a spare cell. Select that cell and copy. Then select the range
of cells where you have your times in hours and minutes that you want
converting to minutes and seconds. Then choose Edit/ Paste Special/ Divide,
and OK. If you get a decimal number at that stage (0.00648148148148148 from
your 09:20), it's because Excel has reformatted the cell to General, so
reformat it to [m]:ss if you want to see 9:20, or [mm]:ss if you want to see
09:20.
--
David Biddulph
NavyPianoMan said:
David, the "divide by 60" isn't working for me--I don't see where I can
put
the "60". Once I select the "divide" feature under Paste Special, and
click
OK, it just results in a funky number. For example, the time "9:20"
results
in "1440:00" when I apply Paste Special and then format as [mm]:ss.
Thanks for any enlightening thoughts.
NavyPianoMan
David Biddulph said:
Enter either 0:13:15 or 13:15.0
If the values are already in the cells & you want to convert, use Edit/
Paste Special/ Divide, to divide by 60.
--
David Biddulph
I need to format a cell as elapsed time for a run time. For example, I
want
to use "13:15" to designate "13 minutes and 15 seconds" and use it in
an
ascending array (VLOOKUP). Right now, Excel makes it into "13:15:00
AM",
which doesn't help me.