Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Working Days, Hours and Minutes Formula

  1. #1
    Join Date
    6th August 2012
    Location
    United Kingdom
    Posts
    6

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    29th October 2010
    Posts
    832

    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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    6th August 2012
    Location
    United Kingdom
    Posts
    6

    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?

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Total Time To Days & Hours, Minutes
    By The Man Room in forum EXCEL HELP
    Replies: 6
    Last Post: April 24th, 2008, 21:10
  2. Replies: 5
    Last Post: October 5th, 2007, 18:25
  3. Time Difference In Days, Hours & Minutes
    By dpw in forum EXCEL HELP
    Replies: 3
    Last Post: September 12th, 2007, 03:16
  4. Format Total Hours to Days, Hours & Minutes
    By dpw in forum EXCEL HELP
    Replies: 9
    Last Post: September 6th, 2007, 05:28
  5. Convert number to days - hours - minutes
    By rsikin in forum Excel and/or Access Help
    Replies: 6
    Last Post: November 9th, 2004, 05:51

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