Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / 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
    Posts
    52
    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.

    Thanks,

    Rod

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    22nd April 2003
    Location
    Virginia, USA
    Posts
    5,035
    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:
    [hh]:mm

    This will allow hours to sum to more than 24.
    Best Regards,
    Tom
    ---------------------------
    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
    Location
    Australia
    Posts
    31,705
    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:
    http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: July 29th, 2011, 02:14
  2. Format Total Hours to Days, Hours & Minutes
    By dpw in forum EXCEL HELP
    Replies: 9
    Last Post: September 6th, 2007, 04:28
  3. Convert Hours & Minutes To Minutes `
    By liz curtis in forum EXCEL HELP
    Replies: 13
    Last Post: July 5th, 2007, 09:49
  4. Replies: 3
    Last Post: December 5th, 2006, 01:50
  5. Replies: 1
    Last Post: December 12th, 2003, 20:04

Bookmarks

Posting Permissions

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