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:
Someone please help! If you can do it thanks, but show me how to as well.
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
Have you tried just using AVERAGE(C2:C21)? where C2:C21 contain the Duration Hours for group 1. Do similar for group 2.
Bookmarks