Excel calculator shift night

[nerxhan]

Hello Masters,

I'm newbie on excel. I make a lot of research. I hope you can help me.

Can somebody advice me how to do this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Turn[/TD]
[TD][TABLE="width: 124"]
<tbody>[TR]
[TD="class: xl64, width: 124"]Start First Turn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl66, width: 106"]End First Turn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl66, width: 117"]Total First Turn(minute)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 114"]
<tbody>[TR]
[TD="class: xl66, width: 114"]Start Second Turn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 107"]
<tbody>[TR]
[TD="class: xl66, width: 107"]End Second Turn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl66, width: 127"]Total Second Turn(minute)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 119"]
<tbody>[TR]
[TD="class: xl66, width: 119"]Start Third Turn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl66, width: 98"]End Third Turn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="class: xl66, width: 188"]Total Third Turn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 201"]
<tbody>[TR]
[TD="class: xl65, width: 201"]Extra Time From Turn One[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 201"]
<tbody>[TR]
[TD="class: xl65"]Extra Time From Turn Two[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 201"]
<tbody>[TR]
[TD="class: xl65"]Extra Time From Turn Three[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9:03:00 AM[/TD]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 106, align: right"]11:07 AM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 117"]
<tbody>[TR]
[TD="class: xl65, width: 117, align: right"]125[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 114"]
<tbody>[TR]
[TD="class: xl65, width: 114, align: right"]10:16 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 107"]
<tbody>[TR]
[TD="class: xl65, width: 107, align: right"]11:21 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl65, width: 127, align: right"]65[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 119"]
<tbody>[TR]
[TD="class: xl65, width: 119, align: right"]11:45 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="class: xl65, width: 98, align: right"]2:13 AM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 188"]
<tbody>[TR]
[TD="class: xl65, width: 188, align: right"]148[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I calculate Total minute from the turn one, two, three, but I have a big problem to get minutes if they are on "night shift one" or "night shift two" from "turn one", "turn two", "turn three".

The first night shift
start at: 22:00
end at: 24: 00

The second night shift
start at: 24:00
end at: ~5:00



Thank you so much.

 

[nerxhan]

Hi @Steve.

Did you have time to see it.


Thanks