View Single Post
  #4   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 add time that I entered in only minutes and seconds

One problem is that if you try to enter times in minutes and seconds, Excel
will tend to treat it as hours and minutes.

If you type in 12:34, Excel will read it as 12:34:00
To get 0:12:34, you need to type either 0:12:34 or 12:34.0

If you've already got all your times in the system and they are hours and
minutes, you can turn them to minutes and seconds by putting 60 into a spare
cell, select and copy, then select your range of times, Edit/ Paste special,
divide.
--
David Biddulph

"greg" wrote in message
...
I have a series of times that are 11 minutes and less and want to add them
but cannot figure out how. I found the format [mm]:ss but don't know how
to
use it