Forum

Hello Jaginder, Welcome to MOTH. Please describe your issue in detail, what is it that you need help with? It might seem obvious for you, but fo...

Hello, Sorry, no file attached. If you’re having problem with getting correct results using AND / OR logic then perhaps this article can give you s...

Of course this was posted in another forum as well.

Hello, It has gone several years now since I worked with Salesforce, so my answer is based on what I got to learn back then. No, Power Query onl...

Hello, Something in line with this result perhaps? In Power Query, add a custom column as a new step to your tbl_2396 query and add following fo...

Hello, The best training is of course to familiarize with the system, learning what can and can’t be done. There are lots of books and courses, som...

Hello, You need to play around creating some conditional rules to control what custom number format should be applied. I wonder of what good usage ...

Hello, See attached, if this is not the result you want then please give an example. I used the same formula as provided earlier. Br, Anders

Hello, You can use following formula to get what you want. =IF(AND(I8=I9,I9="Yes",B9=C8),(C9-B9)-1, IF(AND(I8=I9;I9="No"),NA(),C9-B9)) Br, An...

Hello, I have added another solution using IF and MROUND functions. See attached file, sheet IF solution. The numbers adds up nicely. Br, Anders

Hej Mattias! Have you tried using the MROUND function? To round to nearest 15 minutes you simply use the multiple of 15/(60*24), so the formula sho...

Hello Mike, No, didn't even know about it until now. Anything specific you wonder about it? Br, Anders

Hello Mirjana, Welcome to MOTH. Please read these forum rules, you will understand why as soon as you start reading it. Read This First | Forum Rul...

Hello, I am not clear with what you need help with, I mean, you have the values there. Can you examplify with how you want it? Apart from that, ...

Hello, This is not a forum for SharePoint, I am sure you know that. Anyway, check this support page. --> SharePoint help & learning - Mic...