1 person = 40 hours

[jga5675]

Hi everyone,

I have two columns for full time and part time associates. What i want to do is for every full time person to be 40 hours and part time 20 hours, then total the hours in another column.

ex. if i input 5 full time people the total would be 200 hours and if i input 2 people, it would total 40 hours. In the last column it would show 240 hours.

can anyone shed light on this? Thanks!

[NBVC]

How does one know who is full time and who is part time?


Maybe a sample of your layout would also help.

[oldchippy]

Hi everyone,

I have two columns for full time and part time associates. What i want to do is for every full time person to be 40 hours and part time 20 hours, then total the hours in another column.

ex. if i input 5 full time people the total would be 200 hours and if i input 2 people, it would total 40 hours. In the last column it would show 240 hours.

can anyone shed light on this? Thanks!

Hi,

There are a number of ways, here are three, there are probably more

[jga5675]

Thanks Chippy..i will try it and let you know how it works out!