PerS
12-02-2008, 06:49 AM
Hi
I receive spreadsheets from different departments with time-data and I need to transform them into data that fits in our payroll system. The input looks like this:
1825 abc 3001 17,5 3,5 3,83 0
2653 def 3001 69 21 5,75 7
1883 hij 3001 33,75 2 4,25 4,5
where column A = Employee no, B = Name, C = Department, D = Normal Hours, E = Evening Hours, F = Saturday and G = Sunday Hours.
I want to copy the data into a new worksheet "Sheet2" in this format:
1825 Normal 17,5 3001
1825 Evening 3,5 3001
1825 Saturday 3,83 3001
2653 Normal 69 3001
2653 Evening 21 3001
2653 Saturday 5,75 3001
2653 Sunday 7 3001
1883 Normal 33,75 3001
1883 Evening 2 3001
1883 Saturday 4,25 3001
1883 Sunday 4,5 3001
where column A = Employee no, B = Type of hour, C = No of Hours, D to H = blanks and I = Department.
Row 1 gives new 3 rows (0 hours is not written in the output), row 2 and 3 gives 4 new rows.
How do I solve this problem ?
I receive spreadsheets from different departments with time-data and I need to transform them into data that fits in our payroll system. The input looks like this:
1825 abc 3001 17,5 3,5 3,83 0
2653 def 3001 69 21 5,75 7
1883 hij 3001 33,75 2 4,25 4,5
where column A = Employee no, B = Name, C = Department, D = Normal Hours, E = Evening Hours, F = Saturday and G = Sunday Hours.
I want to copy the data into a new worksheet "Sheet2" in this format:
1825 Normal 17,5 3001
1825 Evening 3,5 3001
1825 Saturday 3,83 3001
2653 Normal 69 3001
2653 Evening 21 3001
2653 Saturday 5,75 3001
2653 Sunday 7 3001
1883 Normal 33,75 3001
1883 Evening 2 3001
1883 Saturday 4,25 3001
1883 Sunday 4,5 3001
where column A = Employee no, B = Type of hour, C = No of Hours, D to H = blanks and I = Department.
Row 1 gives new 3 rows (0 hours is not written in the output), row 2 and 3 gives 4 new rows.
How do I solve this problem ?