Moyenne des heures...

Bonjour,
déjà il y a un soucis tu a des cellules ou est noter
360h14:54
261h22:19

mais le mieux serais de mettre ton fichier en ligne avec ce lien
https://www.cjoint.com/

marc

Ce sont probablement ces valeurs qui sont en cause :

216h22:19
360h14:54

Ouin, effectivement, il me sort des drôles de valeurs sous cette forme, et si je mets la configuration sous forme 13:30:55 dans format heure, voici les données: mais la moyenne n'ets toujours pas bonne... et je n'ai pas accès au fichier joint du bureau... zut!

D4:

00:15:00
04:04:00
11:40:00

13:40:00
18:20:00

05:54:00

13:44:00
22:12:00
23:35:00
06:15:00
15:57:00
21:27:00
21:43:00
18:06:00
01:27:00
19:00:00
17:47:00
18:12:00
13:26:00
06:15:00
11:20:00
11:06:00
14:19:00
09:36:00

03:06:00

15:06:00
19:00:00
00:57:00
23:56:00

20:43:00
14:10:00
20:03:00
15:04:00
03:00:00
13:05:00
05:10:00
14:45:00

06:45:00

06:29:41

12:20:24

04:03:20

01:31:15
09:41:51

00:18:19
14:25:29
23:19:11
23:15:00
17:36:00
00:58:00
00:05:00
22:02:57
14:55:00
14:00:00
08:05:00
19:57:00
06:01:02
03:30:00
13:10:13
06:39:15
09:05:00
16:20:54
19:17:46
16:04:00
16:06:00
22:11:00
22:08:00
11:51:54
23:55:17
22:55:00
01:25:58
02:51:26
15:30:49
15:00:00
23:43:43
18:37:33
02:11:09
05:26:33
08:19:36

08:14:21
21:10:08
20:15:51
23:42:53

06:06:30
05:13:13
21:04:50
22:52:57
16:23:03
17:32:15
02:55:35
01:56:47
10:04:00

23:38:25

11:15:00

10:07:00

00:15:00

11:20:00
09:00:00

23:57:00

23:57:00

22:30:00
18:29:00

21:19:00
14:36:00
09:57:00
08:06:00

00:47:03
23:35:27
06:47:40
23:38:04
20:50:00
18:23:00
13:26:59
19:41:23
15:46:34
07:27:00
00:53:00
19:18:00
02:24:00

14:26:53
03:53:00
04:38:38

19:04:00
02:11:40
13:00:11
17:51:57
10:17:57
06:15:34
14:34:27
18:08:03
05:02:15

18:46:53

05:11:00

23:06:00
15:06:20

19:09:21
20:09:31
13:10:30
21:09:38
04:15:00
05:08:12
20:52:54
09:35:23
02:31:32
05:22:18

17:30:32

17:43:59
21:04:00
15:55:15
12:40:09
05:41:09

05:18:18

23:47:00

14:19:00
18:28:00
15:25:00

02:38:00
22:51:00
02:54:00

17:39:00

17:50:00

20:28:51

12:09:19

23:11:27
16:47:02
09:32:54
17:48:57
18:36:12
21:58:55
01:34:14

20:03:28
12:52:05
18:46:09

07:07:15
20:44:57
21:18:00
17:49:00
19:00:00
19:13:00
10:13:00
22:14:00
08:15:00
03:14:00
14:04:00
20:52:00
16:15:00
01:25:00
01:09:00
15:35:00
23:43:00
21:58:00
07:36:00

17:28:00
09:13:00
12:47:00
15:29:00
23:01:00
13:38:00

18:22:01
21:28:05
08:30:30
00:39:26
01:40:40
15:19:22
19:57:55

08:52:59

18:00:00

22:38:00

11:47:05
20:10:00
20:21:00
08:45:00
20:25:00

15:37:00
03:58:00

02:06:00
02:16:00

15:27:00
15:59:00

16:26:00

16:31:34
16:04:42

22:48:00

13:28:00
11:20:00
14:14:00
00:46:00
15:32:00

10:19:54

16:27:54
12:53:32
03:57:35

19:27:38
18:50:44
20:45:23
15:31:56
18:25:18
18:27:51

08:27:55

11:58:00
06:37:53

17:53:32

04:41:19

18:47:09

03:39:26

10:10:08
17:10:30
16:44:36
21:57:43
17:41:06
17:38:42
20:08:02
19:49:08
21:57:09
04:11:28
18:37:00
12:43:37
08:30:08
19:43:08
15:09:15
16:39:10

16:53:35
22:18:54
06:19:03
18:08:08
22:36:52
00:21:01
16:08:32

01:38:44
08:22:49
23:50:58

02:54:45

19:40:00

15:24:00

22:29:26
11:45:12
22:02:42
15:22:45
11:56:07
11:55:12
23:51:10
23:02:32

23:35:12

19:54:52

18:46:00

02:10:00

05:16:59
05:45:01
21:22:00

07:46:18

04:13:18
04:43:00
17:36:00

15:46:38
14:43:40
12:34:01
12:23:29
07:16:19
06:51:33
08:48:24
09:48:39
15:02:07
20:52:50
19:29:56
00:37:44
18:08:01
13:42:46
22:32:57
09:50:52
06:34:05

18:47:09
00:58:40

22:13:35

13:30:30

15:59:47
12:05:07

13:38:29
22:14:00
13:45:16

18:00:30

05:43:31
15:57:30

10:27:14
13:42:16

17:07:00
17:16:00
09:58:00
13:51:00
21:29:00
16:10:00
21:00:00

12:06:22
03:01:00

12:15:00
20:32:00
13:21:00
11:55:00
03:22:00

19:44:00
01:27:53
00:07:51
21:45:00

22:44:00

15:35:00

21:23:00
01:57:00
14:29:00
16:30:00
04:06:00
13:00:00
16:57:51
14:39:00
16:49:00

23:48:58

20:58:38
21:35:53
03:07:00

18:30:04

08:29:46
11:41:00

21:56:28
04:55:00

00:29:00
21:05:00

16:51:00

11:14:11
12:11:00
09:30:25
18:50:00
12:48:22
16:33:05
20:05:39
19:34:23
20:08:00
14:30:57
20:39:44
17:13:15
03:55:40
21:36:19
15:38:18
11:12:07
15:49:28
20:59:23
19:32:33
10:03:51
18:29:57
19:31:15
17:59:19
18:45:53
20:08:55

08:30:16

15:39:00
04:21:00
13:09:00
20:21:00
21:30:00
13:44:00
11:41:00
12:02:00
16:54:00
10:12:00
23:32:00
11:50:00
07:16:00
23:27:00
12:02:00
15:50:00
01:49:00
08:53:00
20:30:00
15:26:00
14:19:00
06:30:00
18:19:00
18:19:00
20:55:00
03:43:00
10:59:00
03:27:00
12:35:00
05:52:00
02:05:00
06:28:00
23:41:00
01:44:00
11:44:00
10:17:00
21:45:00
21:33:00
18:57:00
22:14:00
09:20:00
02:00:00
15:43:00
21:15:00
15:05:00
02:51:00
02:52:00
09:57:00
18:50:00
18:08:00
07:24:00
08:50:00
04:35:00
06:09:00
13:23:00
08:04:00
15:54:00
00:14:00
21:40:00
10:56:00
20:46:00
14:39:00
09:22:00
01:51:00
19:05:00
13:17:00
02:15:00
00:26:00

Puis la colonne D2:
14:34:06
16:28:00
21:46:00
12:25:00
07:41:00
16:25:00
22:03:00
19:17:16
08:56:25
19:48:22
19:28:04
21:50:26
09:44:54
23:23:07
07:32:35
07:06:50
11:54:54
11:56:12
09:15:46
23:13:22
16:28:37
23:07:23
13:17:06
20:41:52
12:52:39
14:33:21
16:46:38
12:14:12
13:56:34
20:20:39
23:20:35
21:41:15
13:03:21
23:54:07
10:31:58
20:44:12
14:02:13
19:23:03
10:05:14
11:30:21
08:02:17
01:23:44
08:07:49
23:33:58
22:16:33
15:07:55
13:25:53
15:01:31
22:01:08
18:57:47
18:04:43
09:45:59
02:40:00
13:25:23
08:40:54
19:25:07
21:00:58
15:09:52
20:51:48
13:07:24
18:53:09
17:59:05
16:28:59
02:57:07
04:54:15
08:14:41
12:57:12
03:40:13
11:51:37
19:37:53
20:00:35
22:11:04
14:30:09
14:22:53
20:24:20
11:20:30
21:38:31
10:15:42
03:23:56
04:38:31
03:33:25
09:46:57
08:57:01
20:57:44
11:55:42
22:13:13
10:36:37
19:01:19
20:07:26
02:54:24
00:37:45
03:53:32
14:37:24
20:39:06
18:42:03
22:45:17
17:58:32
10:05:49
11:18:23
10:25:06
10:27:05
22:14:31
11:33:17
21:51:42
15:11:28
11:45:15
11:40:12
23:37:19
22:43:12
00:23:00
22:01:00
22:29:00
00:05:00
06:00:00
14:55:00
14:29:00
22:20:00
05:37:00
02:39:00
07:23:00
18:28:00
04:51:00
05:33:00
17:46:00
21:25:00
15:02:00
14:33:00
18:24:00
03:52:00
11:16:00
04:13:00
07:16:00
16:31:00
23:22:31
00:37:44
20:18:20
09:08:49
12:30:35
08:46:03
19:42:33
10:04:18
15:41:57
15:52:18
12:14:39
17:08:59
18:31:35
20:22:33
11:09:43
21:06:28
12:16:37
15:43:19
10:47:52
17:03:14
17:03:14
16:56:55
07:30:15
08:42:12
12:12:27
00:41:16
08:46:41
13:44:18
08:16:33
14:47:50
14:47:50
16:46:30
13:07:19
13:07:19
13:06:55
02:11:55
17:28:55
10:41:23
11:27:27
21:50:07
09:39:47
01:24:09
20:42:45
16:39:06
17:59:53
08:29:03
13:36:48
18:19:44
19:59:27
17:14:14
20:15:32
04:34:45
03:37:56
20:00:55
00:20:00
13:44:35
14:33:48
01:44:06
12:34:30
21:13:05
23:46:34
16:50:02
20:22:48
21:59:18
07:10:01
17:51:04
07:40:11
06:52:03
15:29:29
03:06:52
07:58:02
02:40:58
22:12:31
14:31:56
23:05:32
20:09:20
10:28:11
14:54:11
19:00:28
16:46:56
14:22:30
02:17:10
10:03:48
13:10:26
21:49:24
22:14:56
11:50:50
12:06:22
08:36:07
21:34:40
14:10:50
11:30:07
11:40:54
08:10:55
16:20:41
22:09:52
23:35:25
14:08:23
13:49:19
19:02:16
12:03:03
13:25:51
11:16:09
15:53:36
11:45:11
16:08:17
13:19:44
20:58:27
02:39:39
05:44:35
19:47:46
00:34:17
00:40:09
20:40:32
06:16:51
17:10:26
07:38:42
04:42:10
22:57:09
19:22:24
02:22:00
17:05:34
02:31:53
02:43:21
05:06:38
15:57:19
02:34:00
08:11:06
17:32:28
20:31:52
03:45:18
12:01:55
18:04:39
12:42:28
22:06:18
21:09:34
02:11:45
17:34:50
15:40:40
18:59:46
17:15:52
22:09:16
15:27:48
21:54:15
17:08:38
21:31:44
17:12:22
03:43:38
14:37:09
15:57:21
09:08:00
15:17:00
09:28:00
03:51:00
18:32:00
04:16:00
01:54:00
06:01:00
04:41:57
05:19:00
21:05:00
20:04:00
08:32:00
11:19:00
07:27:03
07:13:00
03:59:00
04:27:00
17:24:00
15:37:40
22:29:56
01:26:55
19:56:56
13:10:10
10:14:59
13:05:28
22:58:20
13:56:37
11:24:31
00:07:26
11:21:37
20:51:07
18:14:41
12:39:29
22:25:44
10:41:08
11:56:34
17:06:34
07:51:39
09:06:07
11:37:16
08:27:50
10:43:53
09:36:41
14:41:36
00:07:13
09:17:00
17:16:21
22:18:33
14:07:34
21:12:35
02:02:19
14:34:16
21:09:02
01:15:57
16:57:53
11:43:35
23:25:25
06:22:06
14:25:37
11:56:06
10:15:04
11:49:22
12:29:20
00:12:25
19:10:11
09:06:37
07:16:41
23:33:12
13:49:37
04:44:01
15:32:59
14:30:48
12:23:39
12:12:19
07:03:38
06:37:30
08:36:35
09:39:07
14:48:32
20:42:15
19:19:00
00:26:21
17:57:30
13:32:15
22:18:19
09:41:07
06:21:18
03:38:08
08:37:09
15:01:47
14:18:41
20:06:17
11:35:39
22:05:39
11:41:41
20:50:48
15:25:06
19:12:08
10:39:48
11:13:30
15:07:17
20:31:00
20:25:05
00:04:38
20:24:30
05:55:43
14:14:41
11:50:15
14:22:55
23:51:44
04:27:41
08:47:23
22:59:29
02:26:27
01:31:25
01:58:02
04:24:30
17:36:01
10:37:48
12:26:17
18:17:55
06:57:07
08:04:49
13:26:06
10:56:36
02:13:27
03:23:20
04:28:38
03:22:27
12:02:17
15:55:40
06:56:35
23:00:57
01:01:01
11:11:01
22:23:58
13:19:49
13:20:22
14:07:12
14:34:33
09:32:02
07:56:00
15:21:00
18:54:00
19:22:00
11:19:00
18:52:00
16:51:00
22:41:00
19:43:00
19:24:00
21:10:00
16:46:00
22:26:00
08:49:00
12:14:00
12:12:00
22:51:00
14:39:00
08:17:00
08:37:00
16:09:00
01:45:00
17:21:00
20:54:00
10:17:00
13:43:00
09:05:00
22:40:00
22:40:00
22:41:00
07:35:00
13:09:00
09:25:00
14:12:00
17:52:00
20:21:00
13:07:00
05:20:00
22:44:00
14:19:00
08:42:00
19:10:00
08:49:00
18:50:00
18:14:00
00:33:00
08:52:00
23:40:00
08:01:00
21:03:00
04:13:00
00:10:00
02:38:00
05:05:00
05:28:00
12:38:00
19:42:00
16:24:00
20:55:00
21:36:40
13:08:00
06:23:19
05:23:01
19:36:04
19:01:00
19:38:00
16:58:58
02:38:12
21:33:35
22:33:36
13:29:00
00:47:48
02:59:02
01:58:27
13:56:00
14:29:27
16:34:42
13:05:00
15:27:00
09:54:36
16:52:07
18:23:02
16:48:00
13:12:00
15:40:55
13:43:00
18:29:53
10:17:40
02:51:07
03:03:07
06:35:58
23:56:18
13:07:58
21:12:19
20:47:36
13:47:36
12:49:58
21:39:51
06:36:58
04:31:27
20:29:11
02:56:14
17:40:46
18:29:21
20:43:03
15:27:33
20:04:39
21:49:29
20:15:15
00:40:09
04:46:39
11:47:18
11:09:50
23:45:53
14:57:44
18:30:58
00:36:02
16:57:36
07:33:00
21:59:20
05:53:26
18:14:19
13:23:13
20:38:32
21:25:44
20:45:36
15:41:53
11:52:28
11:39:23
00:13:48
01:08:50
17:12:12
13:24:32
21:52:56
13:32:06
22:42:24
19:27:59
19:32:36
17:44:38
13:46:54
15:11:36
19:41:40
05:19:07
15:39:13
18:46:06
10:13:21
13:29:16
21:35:17
18:39:45
10:26:39
01:24:19
23:24:50
19:27:42
01:56:09
11:44:42
18:06:00
13:40:39
01:54:01
11:55:41
18:13:43
17:12:50
11:41:11
22:27:25
01:57:38
00:19:43
12:37:57
19:53:27
17:29:52
23:37:01
18:35:52
03:53:04
20:09:25
19:40:54
19:40:54
01:51:04
15:00:30
10:38:50
08:58:34
10:24:01
03:43:58
15:12:51
17:10:18
22:40:51
22:35:49
07:49:22
16:27:22
18:00:08
18:18:54
20:25:04
10:58:11
19:03:01
04:13:11
18:47:59
00:09:25
08:35:03
01:22:18
14:47:55
11:40:58
17:48:46
19:31:49
02:32:50
15:14:46
20:16:18
13:06:02
14:26:19
04:12:54
17:38:36
00:19:40
14:52:22
04:40:16
19:39:59
11:45:41
10:02:47
01:17:23
12:14:57
10:43:03
17:01:56
13:58:54
16:00:26
23:42:48
10:56:22
18:22:13
17:10:48
15:53:26
21:36:48
19:07:45
18:59:41
22:06:18
22:25:28
17:51:11
22:44:45
07:21:14
21:33:21
09:13:14
12:06:49
17:29:14
08:00:42
13:47:51
20:41:26
19:22:41
15:37:41
12:37:51
13:02:57
13:02:57
23:38:42
00:36:23
05:10:15
21:15:56
18:35:18
14:30:33
14:57:20
21:41:16
15:11:38
04:16:28
00:45:11
14:15:40
14:52:28
14:38:47
23:37:16
22:43:11
19:23:46
08:11:58
11:51:38
15:04:42
11:11:24
10:44:06
14:53:08
10:32:56
00:07:38
23:53:11
20:03:13
10:05:57
02:34:13
12:03:56
19:38:30
14:55:13
22:07:59
05:01:27
22:19:58
17:03:13
17:03:00
17:13:00
09:45:00
13:42:00
21:18:00
15:57:00
20:53:00
10:52:42
17:34:05
18:05:33
11:26:00
02:56:19
11:16:00
12:09:00
20:21:00
13:18:00
11:49:00
03:19:00
06:50:00
19:42:00
01:24:43
00:01:18
21:41:00
10:32:00
22:42:00
11:27:00
15:30:00
08:32:00
21:19:00
01:49:00
14:23:00
16:28:00
04:01:00
12:54:00
16:39:18
14:34:00
16:45:00
13:17:25
23:45:26
03:48:38
20:49:54
21:32:57
02:59:00
16:43:00
18:29:59
19:10:35
08:25:00
11:29:00
02:39:00
21:53:10
04:50:00
17:20:00
00:25:00
21:01:00
23:07:00
18:47:00
17:37:03
21:43:45
22:03:10
03:21:00
16:41:00
12:59:22
15:45:08
18:55:12
09:12:58
17:26:07
15:36:48
15:09:12
22:04:54
18:44:39
10:57:24
06:15:52
19:39:25
16:57:01
15:51:29
18:18:32
00:51:05
02:54:43
13:31:00
23:08:00
09:12:10
04:16:30
13:50:47
05:52:44
15:19:18
00:58:04
14:50:52
13:17:34
16:15:12
23:05:05
23:17:29
16:23:28
20:25:38
14:07:23
13:41:07
00:11:26
15:12:37
08:59:38
02:08:53
01:02:38
09:20:56
15:17:52
18:24:20
16:51:29
18:24:49
14:03:58
09:43:40
07:32:02
12:48:33
19:26:51
00:39:10
05:39:04
02:21:41
19:56:08
10:11:06
00:00:38
11:07:41
12:00:45
09:21:15
18:42:00
12:30:30
16:25:31
19:58:08
19:27:03
20:02:57
14:22:44
20:31:51
17:04:27
03:46:46
21:29:47
15:30:39
11:06:08
15:42:48
20:50:39
19:26:48
09:55:20
18:19:07
19:25:06
17:49:59
18:39:46
20:03:31
20:20:05
11:20:06
12:35:42
20:59:24
17:00:35
00:47:11
11:36:19
11:52:00
11:21:30
18:13:37
22:09:58
19:02:31
08:41:42
16:49:42
15:57:34
11:12:34
17:37:58
15:59:59
17:48:29
15:41:32
11:33:03
13:25:53
18:59:10
05:39:36
19:13:24
11:16:15
15:03:40
20:38:22
08:10:37
16:06:41
22:10:01
10:52:52
16:28:59
22:36:11
13:12:52
16:58:52
15:34:41
05:38:55
17:44:21
13:42:15
11:29:27
00:48:54
11:04:17
23:51:38
14:41:36
07:23:03
18:17:34
18:20:08
15:46:18
01:38:34
15:35:00
04:12:00
13:03:00
20:19:00
21:21:00
13:41:00
11:28:00
11:53:00
16:43:00
10:07:00
23:27:00
11:42:00
07:11:00
23:18:00
11:56:00
15:43:00
01:46:00
08:48:00
20:25:00
15:14:00
14:14:00
06:22:00
18:14:00
18:15:00
20:49:00
03:34:00
10:57:00
03:22:00
12:28:00
05:41:00
01:57:00
06:24:00
23:33:00
01:34:00
11:38:00
10:10:00
21:40:00
21:29:00
18:54:00
22:11:00
09:12:00
01:55:00
15:38:00
21:11:00
14:59:00
02:43:00
02:51:00
09:49:00
18:41:00
18:04:00
07:18:00
08:46:00
04:23:00
06:01:00
13:17:00
07:52:00
15:51:00
00:07:00
21:36:00
10:52:00
20:41:00
14:32:00
09:15:00
01:45:00
19:02:00
13:12:00
02:11:00
00:20:00

me donne comme différences la colonne suivante, colonne dont je veux obtenir la moyenne...

00:44:00
00:47:00
00:32:00

00:08:00
00:14:00

00:13:00

00:22:00
00:12:00
00:17:00
00:19:00
00:17:00
00:15:00
00:16:00
00:10:00
00:16:00
00:15:00
00:11:00
00:12:00
00:23:00
00:18:00
00:12:00
00:15:00
00:10:00
00:19:00

00:31:00

00:18:00
00:18:00
00:17:00
00:30:00

00:19:00
00:47:00
00:20:00
00:30:00
00:30:00
00:35:00
00:26:00
00:26:00

00:14:00

00:19:42

00:26:22

00:15:42

01:56:19
00:17:35

00:11:09
00:11:41
00:10:45
00:09:27
00:18:02
00:13:52
00:10:10
00:13:03
00:16:50
00:09:07
00:23:41
00:16:30
00:14:39
00:11:26
00:08:57
00:15:16
00:14:54
00:08:16
00:11:49
00:00:48
00:00:29
00:26:49
00:22:19
00:00:00
00:00:00
00:25:28
00:20:01
00:06:26
00:13:40
00:13:19
00:26:57
00:10:29
00:10:49
00:12:36
00:16:13

00:14:39
00:21:00
00:20:21
00:15:01

00:13:46
00:31:17
00:18:28
00:10:38
00:15:41
00:18:32
00:12:58
00:15:52
00:09:34

00:33:29

00:56:33

00:10:45

00:12:00

00:18:00
00:08:00

00:14:50

00:21:00

00:17:00
00:17:00

00:14:00
00:16:00
00:15:00
00:16:41

00:45:20
00:13:29
00:15:51
00:42:16
00:12:00
00:11:00
00:06:44
00:16:49
00:44:59
00:08:00
00:09:00
00:49:00
00:18:02

00:06:03
00:27:16
00:30:29

00:09:00
00:12:37
00:15:14
00:43:05
00:12:45
00:18:28
00:12:02
00:13:00
00:10:12

00:12:14

00:11:47

00:09:13
00:10:15

00:11:23
00:11:09
00:11:38
00:11:01
00:07:29
00:10:32
00:08:23
00:12:41
00:19:05
00:11:10

00:12:33

00:12:21
00:13:26
00:12:08
00:08:51
00:15:24

00:10:37

00:24:00

00:32:00
00:18:00
00:15:00

00:14:00
00:20:00
00:15:00

00:18:00

00:17:00

00:14:37

00:11:52

00:31:06
00:23:13
00:16:24
00:14:10
00:18:58
00:21:14
00:21:30

01:25:50
00:21:28
00:59:55

00:18:59
00:14:24
00:12:00
00:13:00
00:14:00
00:14:00
00:09:00
00:14:00
00:07:00
00:15:00
00:11:00
00:15:00
00:07:00
00:09:00
00:10:00
00:13:00
00:13:00
00:09:00
00:09:00

00:05:00
00:11:00
00:09:00
00:11:00
00:11:00
00:06:00

00:08:39
00:07:09
00:17:08
00:11:25
00:12:24
00:08:49
00:13:04

00:20:51

00:17:00

00:12:56

00:17:18
00:17:12
00:18:19
00:12:34
00:13:49

00:17:28
00:39:24

00:17:48
00:07:41

00:25:00
00:20:00

00:13:00

00:11:47
00:12:42

00:21:00

00:11:00
00:11:00
00:49:00
00:13:00
00:11:00

00:07:33

00:10:48
00:20:16
00:19:34

00:10:33
00:17:18
00:17:21
00:24:13
00:20:39
00:13:10

00:08:51

00:11:53
00:18:16

00:27:36

00:42:33

00:14:09

00:11:38

00:24:15
00:13:59
00:12:41
00:16:44
00:22:14
00:10:58
00:24:03
00:10:18
00:09:34
00:15:25
00:10:15
00:09:29
00:06:19
00:43:23
00:17:32
00:09:21

00:07:44
00:11:31
00:07:49
00:07:52
00:10:27
00:06:34
00:56:29

02:26:46

voici ce que je trouve d'apres vos valeurs
en D471 la moyenne

https://www.cjoint.com/?3FCrA2wJ4PJ

marc

opss j'avais pas vue que tu donnais plusieurs colonnes

Bonjour
probablement un problème de formatage. Je ne comprend pas bien votre format: [hh]"h":mm:ss

[hh]:mm:ss devrait faire l'affaire
voila le résultat ici après formatage et re-numérisation des va;leurs de votre message.

crdlmnt

https://www.cjoint.com/?CFCrzqR70zI

Merci groupe, en fait, j'avais 1 mois de différence entre la colonne D2 et D4 sur les deux ligne sproblématiques... si j'arrange le tout, la moyenne deveint à 17 minutes queqlues, ce qui ets plus normal, merci à vous tous!!!