Last seen: Jul 6, 2025
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...
Hello, Not sure what you have tried with, but this only need an empty row 1 and then an ordinary IF function to check if A2 is empty, if true then ...
Hello Andy, Very kind of you, even though I am not a star I gladly try to help. I’m sorry, I don’t intend to help you with a complete file or so...
Hello Andy, Attached is a simple sample file, it is not a final solution, but it gives perhaps a base to build on. With the given layout it gets mo...
Hello Andy, Thanks for the file. Regarding calculating the end time you should be able to crack that nut if you read the good information about dat...
Hello Andy, Seems the file didn't upload successfully, do try to upload it again. Br, Anders
Hello, If you have Microsoft 365, see this blog post on how to import data from PDF files. If you have older version then the easy method is to jus...
Hello Fred, You can reference to defined names in other workbooks, but if there is any new data in any of them you would need to open the other wor...
Hello Ethel, I have added two more columns, N and O, showing earliest and latest time for each date. I hope this gives you the help you want. Br...
Hello Brian, Attached is an example on how to visualize what needs to be checked and perhaps corrected using conditional formatting. Nothing advanc...