Results 1 to 2 of 2

Thread: How to calculate the average time?

  1. #1

    How to calculate the average time?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Have you tried just using AVERAGE(C2:C21)? where C2:C21 contain the Duration Hours for group 1. Do similar for group 2.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •