Recent content by tessam

Thanks for the reply. The above table is correct. For each row under the names it would be the same number. Its 1 staff to 3 persons and that number goes under the name who would need that staff. If its 1 staff to 2 the number would go under the name who would need that staff and the other...

Hello, I am having problems with a formula that would add a column if it matchs two other column criteria. R A T I O' S Code Time Time Hours Gladys Roger Rick AOC 8:00 12:00 4 3 3 3 A0C 12:01 2:00 2 2 0 2 APC...

Longhair, It is protected thru excel's protection. I go to Allow users to Edit Ranges, select ranges,and password then permissions and add. I find the people I want and add them. When I protect the sheet they can't access the ranges I specified. Is there another way to pick the people...

Hello, I have a timesheet in Excel and have the formulas and certain areas locked and protected so that employees can't change them. I have areas unlocked so they can enter in their time. What I can't seem to do is allow certain users to edit locked ranges. I have set up the ranges and...

Hello, I need to extract the oldest date from two columns of dates that are formatted as 02/18. I would like to have a formula to do this. Thanks Tessa

We ordered Omni Page from eagletronics.com for $100. Have really got into how good it is going to be though. Looking for tips on how to use it. Tessa

I am having problem with the 12:00 am time. If a person works from 5:00 pm to 2:00am I get the answer of 15 but it should be 9. I know it is just doing the difference between 17 and 2 which is the 24 hour number. Is there any way to make this happen. thanks Tessam