Calculate total clocked In minutes in a given hour

Hello:

Please refer to attached sheet.

I will be ok with either VB Macro or Formula to perform this task.

I have clockIn-ClockOut information for employees in row 2 thru 16

I want to use this data and separate out to see how many minutes are employees clocked in a given hour.
For example,
on 7/1/2013,
Angela Clockin at 954 and Clocked Out at 1403
Tomas Clockin at 1003 and Clocked Out at 1132

Between
901-1000 the total minutes would be 6
1001-1100 the total minutes worked would be 60+57 (60 min for Angela and 57 Min for Tomas)
1101-1200 the total minutes worked would be 60+32 (60 min for Angela and 32 Min for Tomas)
1201-1300 the total minutes worked would be 60 (60 min for Angela)
1301-1400 the total minutes worked would be 60 (60 min for Angela)
1401-1403 the total minutes worked would be 3 (3 min for Angela)


I have manually calculated minutes for each hour and entered in column D Cell D20:D25

I hope I have explained very clearly.

Please let me know if you any questions.

Thank you

Riz Momin