HarveyH123
New Member
- Joined
- Feb 18, 2017
- Messages
- 8
Hello,
I am trying to create a formulae in powerpivot that calculates time between two date/times, ignoring hours which are down hours
i.e.
If Start Time was 04/01/2018 05:53:00 and End Time was 05/01/2018 07:33:00 the answer should be 1060 minutes.
Attached is the table. Ideally i would want to do this is PowerPivot opposed to normal formula. I hope it will be simpler anyway.
To confirm, any hours in the second table that has a No shouldnt be counted in the time function.
Thanks in advance
Harvey
[/URL]
[/IMG]
I am trying to create a formulae in powerpivot that calculates time between two date/times, ignoring hours which are down hours
i.e.
If Start Time was 04/01/2018 05:53:00 and End Time was 05/01/2018 07:33:00 the answer should be 1060 minutes.
Attached is the table. Ideally i would want to do this is PowerPivot opposed to normal formula. I hope it will be simpler anyway.
To confirm, any hours in the second table that has a No shouldnt be counted in the time function.
Thanks in advance

Harvey

[/IMG]