Last seen: Aug 30, 2025
Hello Mohamed, As per your picture, the problem is because you are working whith an .xls file in compatibility mode. Slicers are not supported in ....
Hi, There are other considerations to take into count when creating a time sheet, for example night and shift work. More about time calculation in ...
Hello Peter, Some more references to start with, check these sites for more information about calculating dates and times. So, now to your i...
Hi Peter, Basic time sheet is easy to do, if you just know how. If you not already have taken one already, I can suggest that you will learn lots b...
Hello Terri, You are not using the same formula in column S. For example: In cell S7 you have =IF(NOT(ISBLANK(R7)),R7,C7) In cell S8 you have...
Hello Mitul, Both 1st and 2nd outlines are needed, if you want to have the data grouped. Click 2nd outline to open up the groups to see the source ...
Hello Mitul, Seems to me your data is not aligned, meaning that you probably have tried different scenarios or whatever could be the reason. In ...
Hi, I have difficulties in grasping what it is you want, but if you can upload a sample file with the data as you show in your pictures I have a ch...
Hello, Some links that gives some more details of the difference accounts. Br, Anders
Hello Mitul, Please refer toto learn more of how to use GetPivotData function. Br, Anders
Hello Mitul, The purpose of using Pivot Table is to structure the data as you want to present it, often by using graphs. Due to the layout of the t...
Hi, Without any details it is diificult to narrow it down, but here are some tips and advises. If you have O365, try this tool. There are lo...
Hello, Check this article, if you scroll down a little you will find a tip on how to sort the months name in fiscal sort order. Br, Anders
Hello John, I think you might get a tip or two from this blog article (and from many others in this site), check it out and see if it gives you any...
Hello, No file is attached. Anyway, my approach would be to get access to all the source data, depending of the quality of the source data, work wi...