Forum Discussion
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 t...
Tim_Jevans Try: =COUNTIFS(Clients!D4:D200,"ü",Clients!G4:G200,"")
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
- I don't follow what you mean - can you explain a bit more?
So as you can see on the spreadsheet I have a column for hours and a column for minutes and in the calculation I have hours gained and hours lost however right now it is in text form which means when i put 40 hours and 15 minutes it comes up as 40.25 gained, however i want it in the format of 50 hours 15 minutes in the same cell, hopefully this was easier Savia
- I understand now. Change the format to a custom number format of hh:mm.