Forum

Hello, To me it seems that Power Automate is the tool for you, have you checked it out? Br,Anders

Hello, From your Data query, do a merge with the FilterList and use left anti join. Br,Anders

Hello, When I open an Excel file I have in OneDrive in Excel Online, via File - Share - Embed this workbook it works fine for me, the iframe code ha...

@shellp_55 Not a PQ solution, but perhaps usable regardless. Br,Anders

Hello, I can recommend the Excel Dashboards course, it gave me a good push into creating fun and somewhat interactive graphics + the time invested w...

@elsabchugmail-com Your issue is that the range of cells you want to sum contains text data type, i.e. the blank cells. Fill your blank cells in Da...

@elsabchugmail-com The data in a tabular format is to be able to easily work with the data, to present the data in a good way you of course need a ...

@riny, it seems the file didn't get uploaded.

Hello, I have no experience of this kind of export from PDF to Excel, but I know there are some tools for this. Have you for example tried exporting...

@elsabchugmail-com I would argue for a change of how you add your raw data, if you have the data in a tabular formatted table then it is easy to ge...

Hello, I have not checked if it works as intended, but this is the reply from Copilot. Dim LastClickTime As DoublePrivate Sub CommandButton1_Click...

Hello, If you also need to compare if the lunch break equals AU1 (30 minutes) then you will have to do same rounding on that value too. AU1 00:30 ...

Hello, Just sharing my thoughts here, all solutions leading to correct data are good solutions. Easier though to use the SUMIF(S) function for this ...

Hello, In G4, use ROUND using 10 decimals. Ex. =ROUND(F4-E4,10) Br,Anders

@billcarson, I believe you get wrong result because you don't have complete data. For example having Break Start time but no Break End time will give ...