K
klafert
I have a spreadsheet that I have sorted 3 columns and I sort of need the
fourth sorted but that would cause the other not to be sorted properly. I am
thinking a need to use an If - Then statement. If e2 = Reg then I2, If e3=
salary then I3, If e4=MT Over then J4, If e5=spec over then J5, etc. Then by
doing this I will have all my regular time in one column and all over time in
the other column so I can have total regular hours and total over time hours
but in the sort I need. I have to have all totals by department so that has
to be the first sort. Anything that has reg in it is Normal time and
anything that has over in it is over time.
The actual layout is as follows:
Dept. State Employee Date Pay Type Pay Hrs. Pay
Amt.
01 la Cheryl Smite 09/07/07 Officer
2,500
01 tx Brad billot 09/07/07 Salary 40
600
02 la Joe Blow 09/07/07 MT Over 31
961
02 tx who knows 09/07/07 E/C Reg 73.00
1,040.25
fourth sorted but that would cause the other not to be sorted properly. I am
thinking a need to use an If - Then statement. If e2 = Reg then I2, If e3=
salary then I3, If e4=MT Over then J4, If e5=spec over then J5, etc. Then by
doing this I will have all my regular time in one column and all over time in
the other column so I can have total regular hours and total over time hours
but in the sort I need. I have to have all totals by department so that has
to be the first sort. Anything that has reg in it is Normal time and
anything that has over in it is over time.
The actual layout is as follows:
Dept. State Employee Date Pay Type Pay Hrs. Pay
Amt.
01 la Cheryl Smite 09/07/07 Officer
2,500
01 tx Brad billot 09/07/07 Salary 40
600
02 la Joe Blow 09/07/07 MT Over 31
961
02 tx who knows 09/07/07 E/C Reg 73.00
1,040.25