title: To find number of hours between start date and end date in excel or power bi?
body: <p>I have a data having two date columns. SHUT HOURS column I calculate after subtracting FEEDON from FEEDOFF date.  I need the information for number of shut hours on each day. If I just subtract FEEDON from FEEDOFF, it will give me total number of hours for all days. But I want for each day. Is there any way where I can  find number of SHUT HOURS on each day from FEEDOFF and FEEDON date?<a href="https://i.stack.imgur.com/6dO2l.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6dO2l.jpg" alt="enter image description here" /></a></p>
  <p>The output I want is in the following picture. For example, for first row I want all dates in different cells corresponding to different number of hours. Is there any way to do that?</p>
  <p><a href="https://i.stack.imgur.com/zdNUR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zdNUR.png" alt="enter image description here" /></a></p>