Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
74
Views
Topic starter
Hi!
Here's a tricky one that someone may have an idea on 🙂
I have a table with start time and an amount of time. For example, start time 09:00, time spell 2.5 Hours.
I would like to split the time by hours of the days. e.g.
Start time 09-10 10-11 11-12
09:00 1.0 1.0 0.5
Any ideas how to achieve this in Power Pivot? Is it possible?
Cheers,
Martin
Posted : 06/09/2016 9:47 pm
Hi Martin,
You'd be best to do this in Excel or maybe Power Query. It isn't a job for Power Pivot.
Mynda
Posted : 07/09/2016 8:41 am
