Thread: How can I format elapsed time as "[mm]: ss" without getting "AM PM
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How can I format elapsed time as "[mm]: ss" without getting "AM PM
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

"NavyPianoMan" wrote in message
...
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.


Reply With QuoteReply With Quote