FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Adding minutes and seconds together

  
   Mac (Home) -> Mac Excel RSS
Related Topics:
Keying in hours and minutes - Is there any way of keying in hours and minutes into a cell e.g. 1hr 45 mins could look like this 1.45. The only thing I was thinking is that Excel would presume that this is a decimal point and therefore the figure after the decimal point would be..

adding times - I have a worksheet with a column of times that I would like to add together. The times are written as 4:00, 3:30, :30, etc. I cannot seem to add a couple of cells, as a test, or add the whole column of times using auto sum. I've tried formating the..

adding to information in a cell - Version: 2008 in Xcel 2004 using a pc if i put my cursor in a cell and select the F2 function i'm able to add to what's already in the cell. how can i do this with mac office o8.

Adding a workbook to an existing workspace - Created a Just realized that I want to add an workbook to this workspace without having to recreate a new How do you add a workbook to an existing nevets2

Adding a menu item in a single workbook - Can anyone tell me how I add a menu item in a single workbook without it becoming part of the template for all other I would also like the menu item to be visible to any others receiving the workbook. Many thanks, Robert Brydges
Next:  Mac Excel: AutoRecover doesn’  
Author Message
linda-lisa

External


Since: Aug 04, 2008
Posts: 1



(Msg. 1) Posted: Mon Aug 04, 2008 11:44 am
Post subject: Adding minutes and seconds together
Archived from groups: microsoft>public>mac>office>excel (more info?)
Version: 2008
Operating System: Mac OS X 10.3 (Panther)

I need to create columns of minutes and seconds, as in 2:45, and have them added together at the bottom of a column. I will have about 60 values that need to be added together. Excel seems to convert 2:45 to 2:45am, and the sum ends up being a clock time. For example, if I add 0:30, 1:30, 12:30, I get a result of 2:30, instead of 14:30. How do I create a function that will give me a total sum of minutes and seconds, rather than the current time after a given number of elapsed minutes?
Back to top
Login to vote
CyberTaz

External


Since: May 06, 2006
Posts: 954



(Msg. 2) Posted: Mon Aug 04, 2008 5:45 pm
Post subject: Re: Adding minutes and seconds together [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Linda -

It's because of the formatting you have applied to the cells. When you
format the cells for AM/PM they're interpreted as Time of Day rather than
Hours & Minutes. Format the cells - including the one with the calculation
using the first format in the Format> Cells - Number - Time [13:30] & you
should have what you need.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 8/4/08 2:44 PM, in article 59b56052.-1 RemoveThis @webcrossing.caR9absDaxw,
"linda-lisa@officeformac.com" <linda-lisa RemoveThis @officeformac.com> wrote:

> Version: 2008
> Operating System: Mac OS X 10.3 (Panther)
>
> I need to create columns of minutes and seconds, as in 2:45, and have them
> added together at the bottom of a column. I will have about 60 values that
> need to be added together. Excel seems to convert 2:45 to 2:45am, and the sum
> ends up being a clock time. For example, if I add 0:30, 1:30, 12:30, I get a
> result of 2:30, instead of 14:30. How do I create a function that will give me
> a total sum of minutes and seconds, rather than the current time after a given
> number of elapsed minutes?
Back to top
Login to vote
Display posts from previous:   
       Mac (Home) -> Mac Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact