Calcalate hours active
Posted on 2013-12-17
I have a spreadsheet which contains a (dynamic) value for "hours worked". From this value (let's say 12) I want to plot a graph showing the hours worked, against all 24 hours in a day.
The middle of the shift is always 01:00AM
So, if hours worked = 12 the graph should show that the shift began at 19:00 and finished at 07:00.
It should be assumed that 1am always represents the middle of the shift. I only want to show whole hours if possible (i.e. I don't want the graph to have to show 30 minute slots, caused by dividing the shift lenght by 2), but this is not a show-stopper.