Timesheet Form

[Eln3ssan]

Hello
How are you my friends!
I hope you will help me to complete this table It is a Time sheet
I want you to create numbers of work time according to the following condition:
in (E8) set valuein [F8:AJ8] random numbers SUM random numbers
in [F8:AJ8]= SET VALUE
in (E8)I want to cancel columns if the month is less than 30 days and not figuring columns of cellsFile

in url
https://docs.google.com/spreadsheet...Ce9oSX3GfHj/pubhtml?widget=true&headers=false

 

[ranman256]

Tho this sheet is good for humans, it is not conducive for the computer to sum data.
Your sheet would have to be customized for every month/year.

Data entry should be a simple layout:

personID, Date, Hrs
3251, 3/1/2018, 8
3251, 3/2/2018, 7

now excel can sum the data by year, month, day, etc. and produce the layout you showed above.

 

[Eln3ssan]

thanks ranman256

this is file
https://drive.google.com/file/d/1u4w-aNxZ-fPTObKi2XLzJ4ZBxqgo5dA-/view?usp=sharing

I use this formula
=IF(K$8="Fr","",IF(COLUMN()=$C$9+COLUMN($I$11)-1,$AN11-SUM($I11:J11),IF(COLUMN()>$C$9+COLUMN($C$11)-1,"",RANDBETWEEN(MAX($A$9,$AN11-(SUM($I$11:J11)+($C$9-COLUMNS($I11:K11))*$B$9)),MIN($B$9,$AN11-(SUM($I11:J11)+($C$9-COLUMNS($I11:K11))*$A$9))))))

but i need tow conditions
sum cell from i11 to am11 = set value
sum cell from i11 to i14= set value

 

[Eln3ssan]

Hi
Any Answer