Forum

Hi Chris, Looks like this post has your answer. Mynda

Hi John, Thanks for further clarifying, however I'd like to make sure I'm understanding correctly. You said: "How can I report the average time ...

Hi John, Sorry, but I don't know what you mean by 'calculating the average minutes for each hour'. The average minutes in an hour is 60 😉 I wa...

Hi Lea, Can you please translate to English as Google translate isn't making sense. Mynda

Hi John, Nothing attached. You need to click the yellow 'Start upload' button after selecting your file. Mynda

Hi Waqas, You can use this array formula where Total Consumed Hours is in column C (enter with CTRL+SHIFT+ENTER): =SUM(({24;48;72;96;120;144;168...

Hi Saliha, You can't test if a cell contains a date specifically, as dates are just numbers, so you're just as well off testing if the cell is empt...

I'm not aware of any magic cure for this, sorry. You could try renaming the file and moving it to your desktop to open it from there, but no guarantee...

It's great to hear you've embraced unpivoting with Power Query 🙂

The SUMPRODUCT(...,INDEX formula is like oil and water. If you evaluate the first and second SUMPRODUCT arguments you'll see why. The INDEX formula is...

Try deleting it and you will see 😉 Without it you cannot pivot because there would be no 'value' data to Pivot.

Hi Macca, You have two places where the dates are getting messed up. First when you paste the dates into Excel, Excel is converting them, then when...

Hi Maccra, I'm not aware of any way to prevent Power Query resizing Table column widths, sorry. You could try Worksheet protection, but this may pr...

Hi Lea, Yes, see example attached. Mynda

I'm confused why your second mock-up showed the values for xyz summarised and now in your third mock-up you're saying you need something completely di...