Last seen: Jul 8, 2026
Could you please upload a file that contains the raw data? That makes it easier to come up with a solution. Thank you!
I created a small example in the attached file, where the following code adds a column with corrected dates for dates after today. let Source ...
Not sure about what that columns represents, but I suspect that you are expressing the total number of minutes as a portion of a whole day, containing...
Isn't that correct? 14:45 is 7 minutes after 14:38.
The report was not attached. Please try again don't forget to press "Start upload" before you submit your reply.
To calculate time spent in Power Query, first select the End time column, press control and then the Start time column. On the Add Column tab press t...
Hi, you probably intended to upload some screenshots, but they didn't come through. Please try again by clicking "Attachments", select the pictures...
Thanks for uploading the file. Perhaps I misunderstood but I believe the attached file contains the solution that you are asking for. Let us know if t...
Please try to upload the file(s) again. This time, don't forget to press "Start upload" before you submit your reply.
If you tried to upload a file to demonstrate the problem, please try again and don't forget to press "Start upload" before you submit your reply.
When you connect to the entire table with Power Query, select the first two columns. Then choose Unpivot Other Columns and it will give you 4 columns....
There is no screenshot. Please try again and don't forget to press "Start upload" before you submit your reply. And, perhaps wise to also upload the f...
Can you please upload a file showing what you have and what you want to achieve, as your question doesn't really reveal much regarding your intentions...
Hi Nancy, It would be helpful if you could upload a file (remove any confidential information but leave the structure as is) to help us get to grip...
Hi Thabani, In case you intended to upload a file, please try again. This time, press the "Start upload" button before submitting your reply. Ri...