Latest activity
-
p45cal replied to the thread If function not working.=IF(ISNUMBER(SEARCH("Money Out",Q5)),-T5,IF(ISNUMBER(SEARCH("Money In",R5)),U5,""))but note that if Q5 contains Money Out AND R5 also... -
SSarah28 replied to the thread If function not working.Okay , but can my formulas be combined. If not, why?
-
p45cal replied to the thread If function not working.cross posted without links: https://www.mrexcel.com/board/threads/can-i-use-sumif-and-if-function-together.1269969/page-2#posts @Sarah28...
-
p45cal replied to the thread I need help with speedometer graph.I realise, @Luis Javier , that you'll have read at your cross posts all about cross posting so don't take this as a pile-on! I have...
-
SSarah28 replied to the thread If function not working.I have come up with two separate functions need then combined in Cell W5 Formula 1 for “money out” =If ( ISNUMBER(SEARCH(“Money...
-
LHello my friends, after reading you for a while and interacting with your recommendations and support for the team of followers, it is...
-
-
Eetaf replied to the thread If function not working.I'm really not understanding the example and your comments You have both in the same row Q & R I'm guessing T = debit - money out U =...
-
SHi My if function is not working in column w I need the formula to depend on the words “ money in” and “money out” . Just not sure...
-
-
AliGW replied to the thread Formula calculation.Try this in M2: =IF([@[Clock In]]="","",MIN(8/24,MIN(20/24,[@[Clock Out]])-MAX(8/24,[@[Clock In]])-(2/24))) It's up to you now to... -
AliGW replied to the thread Formula calculation.4) No - it's 10 hours - you said 0800 to 2000 minus 2, which is 12-2=10. You also said 8 hours, which it's not, and it's definitely not...
-
MMinnal_guy2002 replied to the thread Formula calculation.Hi @AliGW sorry for the not clear message to you, below are the clear ideas for you. 1) eg: Staff come in at 7.23 to punch in but the...
-
AliGW replied to the thread Formula calculation.What do you mean? Just change the column's formatting yourself from TIME to NUMBER or CUSTOM (hh:mm) ... But why would you NOT want it...
-
MMinnal_guy2002 replied to the thread Formula calculation.Thank you @AliGW for you time to update the formula, in the column Total Hrs (L2) we need the total hour calculation not in time format...
-
AliGW replied to the thread Formula calculation.Total: =IF([@[Clock In]]="","",[@[Clock Out]]-[@[Clock In]]-(2/24)) Regular: =IF([@[Clock In]]="","",MIN(20/24,[@[Clock...
-
MDear Experts, Please guide me on how to calculate the working hours. E.G : If the person clock in at 7.30AM and go back home at 8.32PM...
