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
|