Spreadsheet for calculating pay, multiple differentials

[Kittyk4y]

Hello, I am trying to figure out how to make a spreadsheet that can calculate my gross pay. I get a base pay along with zero or one of three shift differentials, depending on when I work. An example is below. What I have right now is a spreadsheet with my clock in and out times, the amount of regular hours, and columns for each of the three differentials. What formula would I use to calculate the time of my shift that is in that differential?

Differential times are as follows:
1 - weekdays 18:00-06:00
2 - weekends 06:00-18:00
3 - weekends 18:00-06:00

My spreadsheet right now looks something like this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Clock In[/TD]
[TD]Clock Out[/TD]
[TD]Total Hours[/TD]
[TD]Regular Hours[/TD]
[TD]Differential 1 Hours[/TD]
[TD]Differential 2 Hours[/TD]
[TD]Differential 3 Hours[/TD]
[/TR]
[TR]
[TD]3/10/18[/TD]
[TD]14:00[/TD]
[TD]22:00[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/11/18[/TD]
[TD]23:00[/TD]
[TD]07:00[/TD]
[TD]16[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/17/18[/TD]
[TD]14:00[/TD]
[TD]22:00[/TD]
[TD]24[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

And it should look like this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Clock In[/TD]
[TD]Clock Out[/TD]
[TD]Total Hours[/TD]
[TD]Regular Hours[/TD]
[TD]Differential 1 Hours[/TD]
[TD]Differential 2 Hours[/TD]
[TD]Differential 3 Hours[/TD]
[/TR]
[TR]
[TD]3/10/18[/TD]
[TD]14:00[/TD]
[TD]22:00[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3/11/18[/TD]
[TD]23:00[/TD]
[TD]07:00[/TD]
[TD]16[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]3/17/18[/TD]
[TD]14:00[/TD]
[TD]22:00[/TD]
[TD]24[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]