Last seen: Mar 8, 2026
Hello Andy, I am no coder, but what you are trying to do requires only basic knowledge of VBA. I do think you want to spend some time and learn the...
Hello, I don’t really follow along with what you want, there is no such thing as 50 minutes hour. What is the usage of such formula? What does it n...
Hello, Have you tried to record a macro? It is good start to get the code created by Excel for each step. How to record a macro in Excel Br, ...
Hello, You can of course record the steps and let Excel create the code. How to record a macro in Excel Br, Anders
Hello, What is the logic behind these colours? Why do some cells get dark grey and others light grey and some no colour at all? These colours are s...
Hello, One way to bring out the Branch is like this. In Power Query Editor; Go to Add Column menu tab and choose Conditional Column. Name thi...
Hello, It would be much better if you upload sample files containing the data. Where do you get stuck? In other words, what have you tried to do? T...
Hello Julie, Your file contains lots of data and I have not yet fully understood what is happening in the file. I take it that it is kind of an inv...
Hello Vincent, Might be that you refer to the old XLM macros used before VBA, there is an article about it that could be of interest. There you hav...
Hello, In order to use Pivot Tables you need to put your data in a tabular format, it makes it a whole lot easier. In attached file I have unpivote...
Hello Julie, No workbook attached. After selecting/adding the file to upload you need to click the Start Upload button. Br, Anders
Hello Vahid, Have you seen this article? It will guide you through. Br, Anders
Hello Rakesh, I have some questions so I know what is the best and/or easiest approach. What version of Excel do you have? If you are using Ex...
Hello, Please see if this Microsoft support article can give you some guidance. Br, Anders
Hello, In my opinion you should go with start time in column C and end time in column D, then you also avoid merged cells. If you do want to keep t...