Last seen: Sep 19, 2025
However without CONVERT the calculation with SUBTRACT/NEGATIVE of NUMBER DECIMAL is incorrect with DATASETS where the Result is that it does not equal...
so if 2 DIFFERENT DATES (FINISH - START) = HOURS ACTUAL (NOT DECIMAL)What is correct FORMULA & FORMAT CELLS? Custom? Ain't it odd basic SUBTRACT (...
Hello What's the Difference between 2 Dates! ? Solved Solution is: =CONVERT(F25-C25,"day","hr") It looks so simple and gladly...
Hello Solved the 3D Indirect Alphanumeric Year myself, 2 versions attached, both 3D Indirect Tabs summary. 1. YEAR date TAB names. 2. Alphanu...
Hello FYI: Posted elsewhere as not intending full REWORK! For what is likely to be 1 formula to correct in EV YEAR TOTAL (Columns B-P). But co...
Hi Anders I understand your theory and did try previous to deconstruct it to the following for the purposes of 1xbreak, but as mentioned before, th...
Hello Anders Your right there are no errors or issues with formula you provided or the worksheet. Just was asking for a variation of ...
Hi Anders 2 more questions, your short-hand formula edit if was just : Q1: BREAK1 START & END, for Row2? Q2 BREAK1&2 START ...
Hello. File Attached. Status: Done/Finished/Ready! Edited rest of workbook (JAN-DEC) with your concise formula, much easier to edit/follow. Ch...
Hello Anders, exactly brilliant, thanks much more concise! Guess only refers end threshold because after midnight is night hours?! When applied to...
Hello Thank you for assistance! again all absolutely right, many thanks. Updated file attached. The use of * I wouldn't have anticipated in the...