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.
|