I have a spreadsheet where I track many things that occur during my day. One of them is time I go to sleep, time I wake up and total time sleeping over x days (last 5, 10 & 30 days).
Here is a sample array formula I use for this (Column A is the date and column J is the total sleep time):
Now, the total time in column J is computed from the start time (column H) and the end time (column I).
I would like to have a formula that works similar to the above but on the START TIME in column H instead of the TOTAL TIME in column J).
So if I went to bed at 10:00PM one day and 10:30PM the next day, I would expect to see 10:15PM as the average time I went to bed. I thought I could modify the above formula to do this but it does not seem to work out like I expect.
Can anyone help me with this problem?