Home

create number of entries based on variable input

%3CLINGO-SUB%20id%3D%22lingo-sub-1007259%22%20slang%3D%22en-US%22%3Ecreate%20number%20of%20entries%20based%20on%20variable%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007259%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20automate%20a%20time%20sheet%20generator.%20problem%20I%20have%20is%20that%20total%20time%20for%20the%20day%20has%20to%20be%20divided%20across%20number%20of%20jobs%20for%20the%20day%20and%20the%20type%20of%20activity.%20I.E.%20if%20I%20have%204%20(VARIABLE%20NUMBER)%20jobs%20for%20the%20day%2C%20the%20time%20is%20equally%20divided%20between%20each%2C%20but%20each%20one%20will%20have%203%20separate%20activity%20entries.%20Job%201%20codes%20LC%2C%20ND%20and%20LC%20etc..%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20automatically%20populate%20cells%20to%20reflect%20this%3F%20so%20that%20it%20outputs%26nbsp%3Blike%20this%3A%3C%2FP%3E%3CP%3E1%7CLC%7C%3C%2FP%3E%3CP%3E2%7CLC%7C%3C%2FP%3E%3CP%3E3%7CLC%7C%3C%2FP%3E%3CP%3E4%7CLC%7C%3C%2FP%3E%3CP%3E5%7CND%7C%3C%2FP%3E%3CP%3E6%7CND%7C%3C%2FP%3E%3CP%3E7%7CND%7C%3C%2FP%3E%3CP%3E8%7CND%7C%3C%2FP%3E%3CP%3E9%7CLC%7C%3C%2FP%3E%3CP%3E10%7CLC%7C%3C%2FP%3E%3CP%3E11%7CLC%7C%3C%2FP%3E%3CP%3E12%7CLC%7C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20formulae%20for%20everything%20else%20sorted.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1007259%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Coxy-2
Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies