Average Time - impossible?

[thepartydj]

I have tried chatgpt for so long, but it cannot get this right, so I am looking for some real help here folks. I want to calculate the total average time for Friday and Monday. Every suggestion ai gives me returns a blank value. Can you please help. Thank You!

Day	Date	Person	Total Onsite time h:mm	Friday	Monday
Friday	23-Feb​	Kendra	4:02​
Monday	26-Feb​	Kendra	2:06​
Friday	1-Mar​	Taelor	5:15​
Monday	4-Mar​		0:00​
Friday	8-Mar​	Kendra	5:17​
Monday	11-Mar​	Kendra	3:25​	​
Friday	15-Mar​	Kendra	4:33​
Monday	18-Mar​	Taelor	2:58​
Friday	22-Mar​	Kendra	4:12​
Monday	25-Mar​	Kendra	2:36​
Friday	29-Mar​	Kendra	5:30​
Monday	1-Apr​	Taelor	2:52​
Friday	5-Apr​	Kendra	4:48​
Monday	8-Apr​	Kendra	2:59​
Friday	12-Apr​	Kendra	4:37​
Monday	15-Apr​	Taelor	3:00​

 

[alansidman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Day"}, {{"Averge Time", each List.Average([#"Total Onsite time h:mm"]), type number}})
in
    #"Grouped Rows"

Book5
	A	B	C	D	E	F	G	H
1
2	Day	Date	Person	Total Onsite time h:mm			Day	Averge Time
3	Friday	23-Feb	Kendra	4:02:00			Friday	4:46
4	Monday	26-Feb	Kendra	2:06:00			Monday	2:29
5	Friday	1-Mar	Taelor	5:15:00
6	Monday	4-Mar		0:00:00
7	Friday	8-Mar	Kendra	5:17:00
8	Monday	11-Mar	Kendra	3:25:00
9	Friday	15-Mar	Kendra	4:33:00
10	Monday	18-Mar	Taelor	2:58:00
11	Friday	22-Mar	Kendra	4:12:00
12	Monday	25-Mar	Kendra	2:36:00
13	Friday	29-Mar	Kendra	5:30:00
14	Monday	1-Apr	Taelor	2:52:00
15	Friday	5-Apr	Kendra	4:48:00
16	Monday	8-Apr	Kendra	2:59:00
17	Friday	12-Apr	Kendra	4:37:00
18	Monday	15-Apr	Taelor	3:00:00
Sheet1

 

[MountainFog]

=Averageif([Day],"Friday",[Total Onsite Time h:mm])