Hi,
I'm hoping someone can help me. I have a spreadsheet which calculates the amount of time for each breakdown in the factory based on a start and finish time. I need to be able to see how much time was spent in each hour of a shift. Morning shift is from 06:45 to 14:45. So for example if the breakdown is from 6:50 and finishes at 7:55 then for hour 1 (6:45-7:45) the breakdown would be 55mins and for hour 2 (7:45-8:45) it would be 10 mins. Does anyone know how I can do this?
Regards,
Tim
I'm hoping someone can help me. I have a spreadsheet which calculates the amount of time for each breakdown in the factory based on a start and finish time. I need to be able to see how much time was spent in each hour of a shift. Morning shift is from 06:45 to 14:45. So for example if the breakdown is from 6:50 and finishes at 7:55 then for hour 1 (6:45-7:45) the breakdown would be 55mins and for hour 2 (7:45-8:45) it would be 10 mins. Does anyone know how I can do this?
Regards,
Tim
