View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Time with minutes and seconds

You need to enter as 0:mm:ss
Otherwise Excel treats it as hh:mm

The AM or PM, and the rest are part of the format (default) for time
These can be changed to say [m]:ss this will show the total minutes,
without converting it/truncating it to hours

Steve

On Thu, 26 Oct 2006 19:09:02 +0100, Mark Foley
wrote:

I am wanting to work with only minutes and seconds on a spead sheet to
add
minutes of cellular time together. When I enter the minutes and
seconds, it
converts to hours. Is their any way to do it. I am also havving the
problem, that it is giving the time a AM or PM in the formula. Thanks
for
any suggestions.