Forum Discussion

Tim_Jevans's avatar
Tim_Jevans
Copper Contributor
Feb 25, 2020

Struggling how to do a calculation

Hi, I am struggling on how to do a calculation, I have attached a spreadsheet below and would like to have a formula that takes the tick symbols of the contract type but only if there is no text in the left and reason column

admin
excel
office 365

11 Replies

    • Tim_Jevans's avatar
      Tim_Jevans
      Copper Contributor
      Feb 25, 2020

      Thank you this has helped perfectly, if possible could you help with my next problem i need to have the total hours gained and total hours lost actually be the hours and minutes instead of text 

      but i can't seem to know how to do it Savia 

      • Savia's avatar
        Savia
        Iron Contributor
        Feb 25, 2020
        I don't follow what you mean - can you explain a bit more?

Resources