Last seen: Jun 14, 2025
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...
Hello, What Excel version are you using? As you use the old .xls file extension I suspect you might use an old version. In general, to find the ...
Hello, I assume you are running Microsoft Windows 10 or 11. Could be an update that didn't get installed correct, Check your Windows Update hist...
Hello, Based on that I always work with data in a tabular format and thus have not experimented with twisting the functions in a scenario like this...
Hello, You can do the calculation in Power Query if you only are interested in the year diffence between end and start date. Extract start and end ...
Hello, The reason I choosed not to reuse your range of data is because it is in wrong format and not suitable as a table. Of course that can be fix...
Hello, Attached is an example which in my view is an easier and better approach, but you need of course an Excel version having the newer functions...