1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel-Adding hours and minutes

Discussion in 'Business Applications' started by Mrs. Limpet, Mar 5, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. Mrs. Limpet

    Mrs. Limpet Thread Starter

    Joined:
    Mar 5, 2003
    Messages:
    3
    I am tryinmg to add hours and minutes in Excel and nothing I try seems to work. By hours ansd minutes I'm looking to add say 8 hours and 30 minutes plus 7 hours and 40 minutes . The answer should be 16 hrs. 10 min. and I get 15 hrs. 70 minutes or a decimal. Can anyone help me with this I'm ready to pull my hair out!:confused:
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,731
    Click on the cell of your total hours and minutes.
    Format-Cells, hit Custom at the bottom and type this in:

    [h]:mm

    :D
     
  3. Mrs. Limpet

    Mrs. Limpet Thread Starter

    Joined:
    Mar 5, 2003
    Messages:
    3
    Thank you Dreamboat!:D That did it! I can keep my hair now!:p
     
  4. maxflia10

    maxflia10

    Joined:
    Feb 24, 2003
    Messages:
    331
    In addition to Dreamboat's solution, you also maybe entering 8:30 and 7:40 as text hence your 15:70
     
  5. Mrs. Limpet

    Mrs. Limpet Thread Starter

    Joined:
    Mar 5, 2003
    Messages:
    3
    Thanks Max, That was part of the problem when I started doing the spreadsheet.:D
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/122284