Hi all,
I am looking to calculate average sleep time for participants in a study.
I have used this measure:
Sleep Time Avg = FORMAT(AVERAGE(sleepSummaryDaily[sleepTime.2]),"HH:MM")
But it is returning a time of 19:58... I think this is due to the participant going to sleep past 12am so therefore the calculation is going clockwise.
Below is the sample data set for this participant which with the measure above is giving me 19:58. I split the sleep time date/time column into date column (Sleep Time.1) and time column (Sleep Time.2)
| CalendarDate | Participant ID | Sleep Time.1 | Sleep Time.2 |
| 15th December 2022 | 1001 | 14th December 2022 | 22:08:00 |
| 16th December 2022 | 1001 | 15th December 2022 | 23:07:00 |
| 17th December 2022 | 1001 | 16th December 2022 | 23:30:00 |
| 18th December 2022 | 1001 | 18th December 2022 | 00:11:00 |
| 19th December 2022 | 1001 | 18th December 2022 | 22:19:00 |
| 20th December 2022 | 1001 | 19th December 2022 | 21:45:00 |
| 21st December 2022 | 1001 | 20th December 2022 | 23:11:00 |
| 22nd December 2022 | 1001 | 21st December 2022 | 23:34:00 |
Thanks
Chris
