User Profile
Lorenzo
Silver Contributor
Joined 9 years ago
User Widgets
Recent Discussions
Re: PLEASE HELP ME!!! Problem With Excel Formatting Not Working?
EDIT Duplicate of PLEASE HELP ME. Excel Time Formatting Not Working? | Microsoft Community Hub where existing replies say +/- the same thing Why do some of the numbers like 28:44 transform into a complete different number when I enter them? Not sure how many times this question has been answered on this forum and others (all have a Search button/icon)... Please carefully review the pink and green tables and you'll understand the Why: Has shown in the blue table, if you apply Custom. Format [h]:mm you will get the desired display of i.e. 28:44 when entering 28:44 (instead of 00:28:44) - However, the actual duration will remain 1day, 4hrs and 44minsRe: Top n vs. Others in Excel
Hi As I understand & assuming it's doable this would require Power Pivot - not sure & not my expertise 😒 However, I believe you should clarify how you expect to distinguish the TOP 5 (in green below) when several years display, ex.: - Based on the Average by column/Brand or something else? - What if the 6th, 7th... value equals the 5th?Re: How to create a multi-tiered percentage-based bar chart?
Hi A 365 dynamic option. With your data formatted as table named Table1 in the below formula: =LET( data, Table1, colsCount, COLUMNS( data ), fieldsCount, colsCount -1, names, TOCOL( IF( SEQUENCE(, fieldsCount/2), CHOOSECOLS(data, 1) ) ), values, WRAPROWS( TOCOL( CHOOSECOLS(data, SEQUENCE(fieldsCount,,2) ) ), 2 ), VSTACK( {"Employee name", "value 1", "value 2"}, HSTACK( names, values ) ) ) (this site doesn't allow me to attach the corresponding file 😔)Re: Top n vs. Others in Excel
Hi 2 days with no reply probably means nobody's ready to re-create existing data (takes time), running the risk it doesn't reflect yours ==> Suggest you share your workbook (anonymized) with OneDrive, Google Drive or the like Also, please mention the version of Excel you run and on which platform (Windows, Mac, Web...) Hope this all makes senseRe: Viva Engage - Photos Not Loading in Conversations
Hi I had no idea what Viva Engage was (https://www.microsoft.com/en-gb/microsoft-viva/engage?msockid=09d76e3572d66fa03c657a1073916ee3). Obviously this has nothing to do with Excel - this forum. Suggest you post your issue in the appropriate Viva Engage community: > Select a Discussion Space (at the bottom of the page)Re: Calculate overlapping hours
Hi To help people who search for existing solutions it would be smart of you to revise the title of this thread with Calculate non-overlapping hours ;-) - Thanks With Power Query > Pivot Report: Added dummy records to those you provided. Looks good to me... #1 Please double-check and confirm (or not). Sample (to download) avail. at: https://1drv.ms/x/c/1cd824d35610aacb/IQCkJLQ4qI2hQ6OG2-ntg7wiATHCsDR7AVWdpHB_O7bJjgs?e=xn9UML #2 Let me know if you prefer a flat Table instead of a PivotTable Report How to use: With your data in TableData > Right-click somewhere in PivotTable Report > Refresh Notes: 1) If you double-click on a number in the [Total Hours] col. of the PivotTable Report a sheet will give you the details of what made that number. However, you might get less records than in TableData as the query filters out some records for perf. reason. As an ex. : on 11/06/25 Freddie has 9 records but double-clicking on his 10.5 [Total Hours] for that date you get 8 records. The one that's filtered out is: because [Start Time] > [End Time] 2) Also filtered out are records, where for the same [Supervisor] on a given [Date], we have duplicated [Start Time] & [End Time] 3) With the provided sample dataset, [Supervisor] Foo isn't reported as it has only 1 record where [End Time] = [Start Time]
