Announcement

Collapse
No announcement yet.

Working Days, Hours and Minutes Formula

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Working Days, Hours and Minutes Formula



    Hello all,

    I've used this site for Excel help for years and thanks to all the knowledgable members who give up their time to help others I have learned so much so I thought it's about time I joined and tried to give something back to others.

    I'm also joining with a question.

    This thread here: http://www.ozgrid.com/forum/showthread.php?t=87732 titled "Work Days And Hours Between Two Dates & Times" almost answers my query and it was a valuable read, however I am still having a bit of an issue.

    As the thread title suggests I am looking to get the number of working days, hours and minutes between two set dates.

    Example: (Sunday) 05/08/2012 11:00 to (Monday) 06/08/2012 09:30 should show as "0 day(s) 0 hour(s) and 30 minute(s)" but in my sheet it shows as "00 day(s) 08 hour(s) 00 minute(s)" for some weird reason.

    I have uploaded my file to show you what I am trying to work with. Thanks in advance!

    If you have any questions please let me know.
    Attached Files

  • #2
    Re: Working Days, Hours and Minutes Formula

    Excel 2010 Tables
    The formula will almost work if you copy it correctly from
    the old thread.
    If you don't want to fudge start/end working hours and include lunch break
    use this:
    http://c3412576.r76.cf0.rackcdn.com/08_06_12.xlsx
    If you get *.zip, don't unzip, just rename *.xlsx

    Comment


    • #3


      Re: Working Days, Hours and Minutes Formula

      Hello there, I can't get that to work as required on my sheet. Is my upload available for download by all members?

      Comment

      Working...
      X