How to calculate the average time?

[CNS88]

Hey guys. I am doing a self change project on changing my sleep behavior and I need help with how to find the average times of two different sets of groups. There are the baseline times and intervention times. Both groups have three subtopics: Time Fell Asleep, Woke Up, and Duration (how many hours I slept). I am not sure how to find the average of each subtopic. Here are the times....

Baseline times:

Fell Asleep	Woke Up	Duration
2:30 AM	10:00 AM	7:30 hrs
4:30 AM	12:30 PM	8:00 hrs
3:30 AM	11:00 AM	7:30 hrs
5:00 AM	1:00 PM	8:00 hrs
3:00 AM	7:00 AM	4:00 hrs
2:00 AM	9:00 AM	7:00 hrs
2:00 AM	10:00 AM	8:00 hrs
12:00 AM	10:30 AM	10:30 hrs
3:00 AM	12:00 PM	9:00 hrs
3:30 AM	12:00 PM	8:30 hrs
3:00 AM	11:00 AM	8:00 hrs
5:00 AM	11:00 AM	6:00 hrs
12:00 AM	10:30 AM	10:30 hrs
4:30 AM	11:30 AM	7:00 hrs
2:00 AM	11:30 AM	9:30 hrs
3:30 AM	12:00 PM	8:30 hrs
1:30 AM	10:30 AM	9:00 hrs
3:00 AM	12:00 PM	9:00 hrs
1:00 AM	11:30 AM	10:30 hrs
2:00 AM	12:00 PM	10:00 hrs
4:00 AM	10:30 AM	6:30 hrs

Intervention Times:

Fell Asleep	Woke Up	Duration
3:00 AM	11:00 AM	8:00 hrs
4:00 AM	12:00 PM	8:00 hrs
1:30 AM	10:00 AM	8:30 hrs
2:00 AM	10:30 AM	8:30 hrs
12:30 AM	11:00 AM	10:30 hrs
11:30 PM	10:00 AM	10:30 hrs
4:00 AM	12:00 PM	8:00 hrs
1:00 AM	9:30 AM	8:30 hrs
1:30 AM	9:30 AM	8:00 hrs
2:00 AM	12:00 PM	10:00 hrs
3:30 AM	8:30 AM	5:00 hrs
1:00 AM	12:00 PM	11:00 hrs
2:30 AM	9:30 AM	7:00 hrs
11:00 PM	7:30 AM	8:30 hrs
2:30 AM	11:30 AM	9:00 hrs
4:30 AM	12:30 PM	8:00 hrs
1:30 AM	9:00 AM	7:30 hrs
2:00 AM	10:30 AM	8:30 hrs
11:00 PM	9:00 AM	10:00 hrs
1:00 AM	5:30 AM	4:30 hrs
12:30 AM	11:00 AM	10:30 hrs

Someone please help! If you can do it thanks, but show me how to as well.

[NBVC]

Have you tried just using AVERAGE(C2:C21)? where C2:C21 contain the Duration Hours for group 1. Do similar for group 2.