Forum Discussion

Copper Contributor

Oct 08, 2020

Formula Help

Hi, i need help with a formula. I have a file that in one column has codes the other column has total of time (basically it's a time sheet for an employee and they code what they did in that parti...

JZ 9.28-10.9.20.xls92 KB

Formulas and Functions

HansVogelaar

MVP

Oct 08, 2020

MelissaChristensen

For example in H29:

=SUMIF(E6:E27,"T ",C6:C27)

Note that I used "T ". This is because the code in Y12 contains a space after T. If you remove this, use

=SUMIF(E6:E27,"T",C6:C27)

MelissaChristensen

Copper Contributor

Oct 08, 2020

Thank you. ! more questions seems my hours are rounding up can you check my ttotals how do i fix thatHansVogelaar

JZ 9.28-10.9.20.xlsx44 KB

MelissaChristensen
Copper Contributor
Oct 09, 2020
HansVogelaar I have 2 codes now "TN" and "TB" if I add them it doesn't work I NEED TO COUNT HOW MANY OF MORE THAN ONE CODE IN A SPECIFIC CELL
- HansVogelaar
  MVP
  Oct 09, 2020
  MelissaChristensen
  
  What is wrong with
  
  =SUM(SUMIF(E3:E27,{"TN","TB"},C3:C26))
HansVogelaar
MVP
Oct 08, 2020
MelissaChristensen

I'm sorry, I don't understand. Can you provide an example to explain what you mean? Thanks in advance.
- MelissaChristensen
  Copper Contributor
  Oct 08, 2020
  so different question, i need to get total hours of billable column e, if "AI", "W" and "CDAM" then add hours in column C it's not working my formulaHansVogelaar
  JZ 9.28-10.9.20.xlsx45 KB
  - SergeiBaklan
    Diamond Contributor
    Oct 08, 2020
    MelissaChristensen
    
    Not sure about formulas, but time is entered incorrectly, for example here
    
    is not 12AM, but 12AM plus 6 days.
    
    If apply elapsed time format, Time Out will be 144:00
    
    Perhaps you need to clean source data first.