Counting total hours for breaks / training at half hour intervals
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!
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?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1