I am looking to compare downtime and production to labor data on an hourly or half hourly basis. My challenge is for my labor data I have a range (punch in to punch out) which I need to put into a 24 hours timeline without dates. We are trying to look at our labor effectiveness over the course of the day to get production/labor hour on an hourly basis to understand if lines are more or less production during different parts of the day or shift.
Can someone help me figure out how I would go about doing this for the example below? Thanks!!!
Example:
Range:
Punch In 6/14/2018 20:15 Punch Out: 6/15/18 5:15
Needed Result:
Hours worked during each hours time period:
Hour 20:00-21:00 - .75 hour
Hour 21:00-22:00 - 1 hour
Hour 22:00-23:00 - 1 hour
Hour 23:00-00:00 - 1 hour
Hour 00:00-01:00 - 1 hour
Hour 01:00-02:00 - 1 hour
Hour 02:00-03:00 - 1 hour
Hour 03:00-04:00 - 1 hour
Hour 04:00-05:00 - 1 hour
Hour 05:00-06:00 - .15 hour
Hour 06:00-07:00 - 0 hour
...
