Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I add time that I entered in only minutes and seconds
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I add time that I entered in only minutes and seconds
Just use SUM as with any number.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I add time that I entered in only minutes and seconds
Use the SUM function and format the cell as [mm]:ss.
=SUM(A1:A10) Then format the formula cell as [mm]:ss The [ ] keep the minutes from rolling over into hours. Without the [ ] : 61 minutes 10 secnds would display as: 01:10 With the [ ] it would display as: 61:10 -- Biff Microsoft Excel MVP "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time in minutes and seconds and .00 | Excel Worksheet Functions | |||
Time with minutes and seconds | Excel Discussion (Misc queries) | |||
Time inputted as minutes and seconds Excel | New Users to Excel | |||
Average time for a race in minutes seconds & tenths | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |