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