Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing minutes and seconds
I want to add minutes and seconds. It is entered into the worksheet as:
3:50 (this represents 3 minutes and 50 seconds) 0:45 (this represent 45 seconds) I've formatted the cells so they are mm:ss If I use a Sum function, it shows 35:00. I'm not sure what this is telling me. It should be 4:35 (4 minutes and 35 seconds). -- Lady |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing minutes and seconds
Although you formatted the first two cells correctly, the data was not
inputted correctly. Input the first time as 0:3:50 and the second time as 0:0:45 Your sum should now work. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lady Success" wrote: I want to add minutes and seconds. It is entered into the worksheet as: 3:50 (this represents 3 minutes and 50 seconds) 0:45 (this represent 45 seconds) I've formatted the cells so they are mm:ss If I use a Sum function, it shows 35:00. I'm not sure what this is telling me. It should be 4:35 (4 minutes and 35 seconds). -- Lady |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing minutes and seconds
Thanks a bunch! It worked!
-- Lady "Luke M" wrote: Although you formatted the first two cells correctly, the data was not inputted correctly. Input the first time as 0:3:50 and the second time as 0:0:45 Your sum should now work. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Lady Success" wrote: I want to add minutes and seconds. It is entered into the worksheet as: 3:50 (this represents 3 minutes and 50 seconds) 0:45 (this represent 45 seconds) I've formatted the cells so they are mm:ss If I use a Sum function, it shows 35:00. I'm not sure what this is telling me. It should be 4:35 (4 minutes and 35 seconds). -- Lady |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions |