I am tasked to calculate Double Over Time, Over Time and Regular.

If an associate works more then:

12 hours = Double Over Time

8 hours = Over Time

Else = Regular Time

For example 1:

16 hours total daily

Type = Double Over Time

Double Over Time = 4

Over Time = 4

Regular = 8

For example 2:

7 hours total daily

Type = Regular

Double Over Time = 0

Over Time = 0

Regular = 7

I will write a Case statements to represent each of the 4 new columns (Type, DT Total, OT Total, Regular Total). As JamesK pointed out, I understand that I can't use a previous "computed" field to calculate the next field. However, I have been impressed with some of the short hand methods on here that I thought I post this question anyway just in case if someone has something impressive. Otherwise, I will just stick to the Case statements. Thanks