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:
<tbody>
</tbody>
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.
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:
Turn |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||||||
1 | 9:03:00 AM |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||||||
<tbody>
</tbody>
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.