Results 1 to 4 of 4
  • Thread Tools
  1. 2 Star Lounger
    Join Date
    May 2002
    Posts
    149
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Calculating elapsed time in hours - Excel 2010

    I've not really used the Excel time functionality before, and I admit I'm finding it a bit tricky!

    I'm trying to create a simple spreadsheet to calculate number of hours to pay someone.

    Information I have is start time, finish time and number of minutes for lunchbreak.

    My simple formula subtracts start time and lunch minutes from end time, to give me total payable hours.

    My problem is when summing these hours, I can't stop the formula expressing the answer in days (whereas I want it to always give me the total number of hours).

    The attached spreadsheet shows the issue. I want the second batch total to read 25:15

    (I predict this will probably be one of the simplest queries ever posted in the Lounge, but try as I might, I can't find the answer myself...!)

    Thanks

    Neil
    Attached Files Attached Files

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. 2 Star Lounger
    Join Date
    May 2002
    Posts
    149
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Sorry, I'm not sure my attachment worked last time...

    This is another attempt to post it.

    Please can someone try to help me with this problem?

    Thanks

    Neil
    Attached Files Attached Files
    Last edited by neil; 2011-08-01 at 08:20.

  4. 2 Star Lounger
    Join Date
    May 2002
    Posts
    149
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I've got the answer folks!

    The column F format needs to be [h]:mm

    Cheers

    Neil

  5. Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    5,540
    Thanks
    176
    Thanked 663 Times in 604 Posts
    Neil,

    You can not do what you want using the time format as when you get to 24 hours it adds 1 day.
    As you can see in the graphic where I adjusted the format to show the date/time on 1st & last entries.
    Attached Images Attached Images
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


Posting Permissions

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