Results 1 to 6 of 6

Thread: How to add total of Hours and Minutes

  1. #1

    How to add total of Hours and Minutes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All

    I need help working out how to calculate hours and minutes
    I entered the values in a cell as 4.15, 10.55, 6.30 etc (4hrs 15mins)
    Is this possible to add total hours and minute. or do I need to enter this in as a different format

    I have included a basic example see attached

    Thanks in advance for the help

    Regard
    Kyle
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by kyle View Post
    or do I need to enter this in as a different format
    I suggest the Time format
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Which are your regional settings?

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Pecoflyer View Post
    Which are your regional settings?
    Thanks for asking, I never thought about it
    My regional settings is 24 hours, Europe - Croatia
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  5. #5
    Take a look at this there's a couple of ways you can do what your looking for.
    It's in the tenth of hours which is what you're looking for.
    Attached Files Attached Files

  6. #6
    Hi Al

    Thank you all so much for your replies, its so much appreciated that something that seems easy enough for some can do your head in..
    Hopefully one day I will be able to help others when they need help.

    Cheers
    kyle

Tags for this Thread

Posting Permissions

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