I really can't understand why this question is not clear. please explain what do you need to know before closing the question. some one put comment and asked some question and I added details to make it clear! if you can't answer, plz let others answer! have start time and end time of each activity for each person. I want to find the activity duration in minutes, which is the end of the time of an activity until the start of another activity.
person start-time-h start-time-m end-time-h end-time-m
1 8 0 10 15
1 11 15 16 35
2 8 10 13 15
1 18 0 23 15
For example, the activity of the first person is from 10:15 until 11:15 so duration is 60 min. and for the second person from 13:15 to 18:00 which is 315 minutes.
person start-time-h start-time-h end-time-h end-time-h ACTDUR
1 8 0 10 15 60
1 11 15 16 35 -
2 8 10 13 15 315
2 18 0 23 15 -
Thank you!