Time with minutes and seconds

M

Mark Foley

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

SteveW

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
 
M

Mark Foley

I am wanting to use the numbers of 2000 minutes and 34 seconds. How do I
keep it in that format without it changing to AM or PM.
--
Mark Foley
Village of Glen Carbon


SteveW said:
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

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.
Click to expand...
Click to expand...
 
D

David Biddulph

Did you have difficulty reading Steve's answer? Format as [m]:ss.
--
David Biddulph

Mark Foley said:
I am wanting to use the numbers of 2000 minutes and 34 seconds. How do I
keep it in that format without it changing to AM or PM.
Click to expand...
SteveW said:
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
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.
Click to expand...
Click to expand...
Click to expand...
 
Top