Forum

Thanks, Mynda

Thanks Mynda, I don't know if rounding to 2 decimal places would work: 5.6 would appear as 5.60, for example. At present I'm extracting from several E...

Hi Mynda, That lesson doesn't address my issue - it's looking at multiple sheets, I'm using multiple folders. Whenever I attempt your suggestion, I...

Thanks Mynda, thanks for that.

And now I see that there's a built-in Calculation for this on the Add Column tab... 🙂

For the benefit of anyone looking for a solution, the following formula gives me the days' duration, formatted as Whole Numbers: = Date.From(DateT...

Thanks, Mynda. It's sorted.

What do I need to do so that the new query doesn't load to another worksheet? And I'm unable to download the data, I'm getting an error msg: [Expr...

Thanks, Mynda, that's working fine. At present, the second query is created by removing the other rows and columns (leaving the single cell G4); is th...