Feb 25 2020 03:02 AM
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
Feb 25 2020 03:49 AM
@Tim_Jevans Try: =COUNTIFS(Clients!D4:D200,"ü",Clients!G4:G200,"")
Feb 25 2020 03:53 AM
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
Feb 25 2020 04:14 AM
Feb 25 2020 04:17 AM
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
Feb 25 2020 05:56 AM
Feb 25 2020 06:08 AM
I did that, however, it then says 06:00
Feb 25 2020 06:22 AM
Feb 25 2020 06:40 AM
I'm sorry to bother you but I don't understand it aha. are you able to help me solve this problem I need the minutes and hours adding up and being shown in an hour hour hour hour minute minute format
Feb 25 2020 06:52 AM
Feb 25 2020 06:57 AM - edited Feb 25 2020 06:58 AM
I have added it to the hours lost formula =SUM(SUMIF(Clients!G4:G200,"*",Clients!B4:B200)+CONVERT(SUMIF(Clients!G4:G200,"*",Clients!C4:C200),"mn","hr")/24) and it is returning 00:15 in the hh:mm format when the hours is 40 and the minutes is 15
Feb 25 2020 07:50 AM