+ Reply to Thread
Results 1 to 2 of 2

Counting total hours for breaks / training at half hour intervals

  1. #1
    Registered User
    Join Date
    08-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    45

    Counting total hours for breaks / training at half hour intervals

    Hi Guys,

    I have a project that i'm working on and it's giving me a bit of grief at the moment. If you can help at all it would be much appreciated!

    Essentially what i'm trying to do is have chart broken into half hour intervals throughout the day (8:00AM - 8:00PM) and be able to see the total of hours of each segment (eg. breaks, training) for each half hour interval

    I have a data source that will give the various start times and finish times for these segments, and I just need to figure out the formula to count the total hours, for each segment, for all employees at each half hour interval.

    I have a sample sheet that I have created that will give you some idea. I have filled in the results that I should see in the compiler tab, and I have included sample data that is very similar to what i'm working with. If you could even point me in the right direction I would be forever greatful! Also if you would like me to elaborate on anything please let me know.


    Thankyou in advance!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-15-2010
    Location
    California, United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: Counting total hours for breaks / training at half hour intervals

    How come Total Break Time (HH:MM) at 4:00 correspond to 1 and Total Break Time (HH:MM) at 4:30 correspond to 0.5? Shouldn't Total Break Time (HH:MM) at 4:00 be 1.5?

+ 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