I just need a formula, or formulas that will calculate my shift Differential
Time from 8pm-8am. So if you work any hours between 8pm-8am(the next day)
those hours apply to shift diff. Also i need another column that calculates
the OT, (over 8 hours) ;and also one column that calculates any hours worked
over 8 hours that are past 8pm; also another that calculates double time (any
time worked over 12 hours)

Shift Diff + Hours = 8 hours always

So the header should read:
Start, End, Shift Diff Hours, Hours work, OT hours, Shift Diff OT, Double Time


Example 1:
So if I worked: 0600 - 2100 on 8-5-08

I would have 2 hours of shift diff, 6 hours of regular, 4 hours of OT, 1
hour of Double Time

(There is no such thing as Shift Diff Double time Any time worked over 12
hours is always DT)

Example 2:
0800 - 2100

8 hours of Regular hours, 4 hours of OT, 1 Hour of Shift Diff OT.

If anyone could help Please Please let me know. i'm not proficient in Excel
to create something like this.
Thanks!