Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time with minutes and seconds
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. -- Mark Foley Village of Glen Carbon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time with minutes and seconds
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" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time with minutes and seconds
Did you have difficulty reading Steve's answer? Format as [m]:ss.
-- David Biddulph "Mark Foley" wrote in message ... 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" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG | Excel Worksheet Functions | |||
Time inputted as minutes and seconds Excel | New Users to Excel | |||
Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |