+ Reply to Thread
Results 1 to 8 of 8

Difference Between Time based off of a 10 Hour Workday

  1. #1
    Registered User
    Join Date
    09-24-2018
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    13

    Difference Between Time based off of a 10 Hour Workday

    Hello,

    I currently track products that go through our plant with a start time and a end time.. I am trying to have a function that takes the difference between 2 dates and times to tell me how long a item took to get through the plant and outputs the total hours.. But I don't want to track all hours in the day.. Only our work shifts..

    Our shifts work 6AM to 4:30PM. We have a 30 minute break from 9:00AM to 9:30AM and another at 12:00PM to 12:30PM

    I want to be able to see the difference in time and the total hours it took to build it and output it without counting all the hours in the day, only counting work hours.
    Attached Files Attached Files
    Last edited by jclaborn; 01-11-2019 at 10:43 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,373

    Re: Difference Between Time based off of a 10 Hour Workday

    Paste this code in to a macro module

    Please Login or Register  to view this content.


    Then enter this formula into cell H22

    =WorkHours(F22:G22)
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Registered User
    Join Date
    09-24-2018
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    13

    Re: Difference Between Time based off of a 10 Hour Workday

    Thank you bud.. Im not too familiar with Macro Modules and how to use them. Can you provide me some additional assistance?

  4. #4
    Registered User
    Join Date
    09-24-2018
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    13

    Re: Difference Between Time based off of a 10 Hour Workday

    I think I figured it out.

  5. #5
    Registered User
    Join Date
    09-24-2018
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    13

    Re: Difference Between Time based off of a 10 Hour Workday

    When I try to count the hours over a span of a few days, it doesn't give me a accurate total number of hours.. So if I started a project at 1/5/19 at 1:00PM and ended the project at 1/9/19 at 1:00PM it outputs zero.. Need it to count total difference in hours but no more then 10 hours per day increments..
    Last edited by jclaborn; 01-11-2019 at 10:30 PM.

  6. #6
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,373

    Re: Difference Between Time based off of a 10 Hour Workday

    1/5/19 at 1:00PM to 1/9/19 at 1:00PM = 342
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,958

    Re: Difference Between Time based off of a 10 Hour Workday

    Is this right?

    O22 and custom format to [h]:mm

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Bo

  8. #8
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    13,905

    Re: Difference Between Time based off of a 10 Hour Workday

    Quote Originally Posted by Sulprobil View Post
    Google for
    [deleted]

    Regards,
    Bernd P
    It is not acceptable to use a post to drive traffic to your own web site.
    Jeff

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會

    If someone helped you please click on the star icon at the bottom of their post
    If your problem is solved please go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1