Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tessam
  • Content: Threads
  • Order by date
  1. tessam

    Sum column based on two other columns criteria

    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...
  2. tessam

    Excel Protection and Allowed Users

    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...
  3. tessam

    Get oldest date from two columns in Excel

    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
  4. tessam

    Excel time Calculations

    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

Part and Inventory Search

Back
Top