Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: Formulas : How to add up minutes and hours

  1. #1
    Join Date
    15th July 2003
    Not needing a full out timecard type spreadsheet. Just need to add up all minutes and hours and return a total in hours. I.e. if in two columns the first column lists projects by type and the second lists duration of the project. What mechanism will allow easy entry of the duration times (.25, .50, .75) or (15, 30, 45) and a way to add up all of the minutes and return the total in hours.



    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    22nd April 2003
    Virginia, USA
    Either format will work, as long as you stay consitent.

    The decimal format (e.g., 2.5 or 1.25) obviously will add just like normal numbers.

    You also can use normal hh:mm format (e.g., 6:30 or 8:15) and sum them with the normal SUM formula. The trick is to use CUSTOM FORMATTING for the cell with the sum.

    FORMAT > CELLS > CUSTOM > and set the format to:

    This will allow hours to sum to more than 24.
    Best Regards,
    Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

  3. #3
    Join Date
    24th January 2003
    Hi rbjexcpa

    It would save you a lot of grief later if you enter them as true minutes. Eg 0:15, 0:30, 0:45 then use the SUM function inside (as thomach suggests) as cell formatted as [h]:mm

    If you stast using decimal times etc Excel will not regonize them as True times and you will need to convert them to true times, eg =A1/24

    See this link for details on dates and times in Excel:

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Converting Minutes into Hours and Minutes using a Formula
    By Gingie Cat in forum Excel General
    Replies: 6
    Last Post: July 29th, 2011, 02:14
  2. Format Total Hours to Days, Hours & Minutes
    By dpw in forum Excel General
    Replies: 9
    Last Post: September 6th, 2007, 04:28
  3. Convert Hours & Minutes To Minutes `
    By liz curtis in forum Excel General
    Replies: 13
    Last Post: July 5th, 2007, 09:49
  4. Convert Hours to Minutes. Display Total Minutes
    By oafum in forum Excel General
    Replies: 3
    Last Post: December 5th, 2006, 02:50
  5. Replies: 1
    Last Post: December 12th, 2003, 21:04


Posting Permissions

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