hy,
when i paste workhours from monthly schedule, for ex. a1=12 (day shift), and b2=12 (4 hours of day and 8 hours of night shift) and so on for all days in one month (two rows), a need to run a macro to automaticaly change value of b2 cell to 8, and to enter a2 cell value 4... (to split night hours for calculating paycheck).. - only second row where there is a cell value, cell changes and cell above... two rows are for one person, than c,d for other, e,f for another and so on.

Thanks