Nov 13 2019 05:41 PM
Hi all,
I'm trying to automate a time sheet generator. problem I have is that total time for the day has to be divided across number of jobs for the day and the type of activity. I.E. if I have 4 (VARIABLE NUMBER) jobs for the day, the time is equally divided between each, but each one will have 3 separate activity entries. Job 1 codes LC, ND and LC etc..
Is there a way to automatically populate cells to reflect this? so that it outputs like this:
1|LC|
2|LC|
3|LC|
4|LC|
5|ND|
6|ND|
7|ND|
8|ND|
9|LC|
10|LC|
11|LC|
12|LC|
I have the formulae for everything else sorted.