making bins in excel

Hello,

I would like to put some time-recorded data (actions) into 1-minute bins. The actions are recorded one after another so I want to divide the total time per person in 1 minute bins and know what the action in that minute is...


For example these are the data:
Person Action Time
1 4 12:01:44
1 4 12:02:58
1 3 12:05:78
1 1 12:10:09
2 3 12:11:07
2 1 12:12:00
2 1 12:14:09
3 1 12:19:80
3 4 12:20:10
3 4 12:23:11
3 3 12:23:19
3 3 12:30:17

what I would like is to make 1 minute bins of the actions from the beginning to the end of the trial per person:
Person Action Minute
1 4 1
1 4 2 etc, etc.

Please help me, I can only find how to make frequency bins and that is not wat I want...

grtz, Iewse

Does the time for a new person start over at 1 minute or does it continue on from the last person? i.e., Should the fifth line of data read 2 3 11 or 2 3 1?

Thnx for your reply!The time continues after person 4 or it may start over at 11:03:02 because the recordings are made on different days ( I also have a column with a date).
I hope you can help me
Grtz, Iewse