Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding minutes (2003)

    If your minutes are to be added to a cell that already contains a time, and your minutes are entered as a time you simply add the cells:

    =A1+B1

    If the minutes are entered as a number, and the other cell has a time, devide your minutes by 60 and by 24:

    =A1+B1/24/60

    Format your cell as time to see the proper time.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    New Lounger
    Join Date
    Feb 2009
    Location
    jacksonville, North Carolina
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adding minutes (2003)

    We are doing a time study to collect how much time is spent on a given task. Is there a formula for adding minutes - 30 min, 1 hour 50 min, 4 hours 15 min? I think what I am trying to do is to add up the minutes to come up with a total number of minutes, not time, hope that is makes sense.

    for example I work on one project for 30 minutes one day and 1 hours and 15 minutes the next day what formula can I use to calculate the correct amount of time that it took to complete the task over the two day period.

    hope that this makes it clearer as far as what I am attempting to do thanks a bunch

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: adding minutes (2003)

    Welcome to Woody's Lounge!

    If you enter the indidual times as times, i.e. 0:30, 1:50, 4:15 etc. in (say) A1:A10, you can add them and display the sum as minutes as follows:
    - In the cell where you want the total, enter the formula =SUM(A1:A10)
    - With the cell still selected, select Format | Cells...
    - If necessary, activate the Number tab.
    - Select Custom in the list of Categories on the left.
    - In the Type box, enter the custom format <!t>[m]<!/t>
    - Click OK.
    The square brackets tell Excel that a number of minutes over 59 is allowed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •