Minutes by hour needed

[reblwalsh]

I've been struggling with this for some time. I have large quantities of data where I'm given a start and stop time. I need to count minutes used by hour.
Ex:
Start 17:30
End 20:05

Outcome
17:00 = 30
18:00 = 60
19:00 = 60
20:00 = 5

Right now I have column A as my start times, B as my end times and C-Z as each hour of the day (0000-2300)

Help!

 

[Joe4]

Welcome to the Board!

Assuming your data begins on row 2, enter this formula in C2, and copy out to column Z for all rows:

=MAX(MIN(C$1+(1/24),$B2)-MAX($A2,C$1),0)*1440

You will need to format your cells as Number with zero decimal places to get the numbers like 30, 60, 60, and 5.