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