Forum

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 ...

@ingaiyoung, I will try to answer, assuming it is the LookupResults names in the LET formula that you are wondering about. Even though Mynda has given...

Hello, See attached file for one solution. If you're using old Excel version then this will not work for you. To simplify things I suggest you w...

Hello, It is possible with VBA, as I am not using VBA myself I am not able to write some code for you. Added below is the answer from one of the AI...

Hello, You should move in the SEQUENCE part to the month section in the DATE function, as in below example: =TEXT(DATE(2024,SEQUENCE(12,1,3,1),1...