Sujet Précédent Sujet Suivant

Moyenne des heures...

brustus Messages postés 12 Date d'inscription   Statut Membre Dernière intervention   -  
brustus Messages postés 12 Date d'inscription   Statut Membre Dernière intervention   -
Bonjour groupe! J'ai une question concernant une formule de moyenne d'heure dans excel... ma configuration de cellule est la suivante: [hh]"h"mm:ss , j'ai des cellules vides et des cellules à zéro. Dans un autre fichier excel, j'Ai tenté de faire un tri aifn d'éliminer les 0 et les vides, mais peu importe, la moyenne obtenu ets toujours de 02:26:46 alorsq qu'aucun temps ne dépasse plus d'une heure quelque... comment faire alors? C'est quoi le problème?

Voici m'a liste de données, merci à l'avance!:

00:44:00

00h44:00
00h47:00
00h32:00

00h08:00
00h14:00

00h13:00

00h22:00
00h12:00
00h17:00
00h19:00
00h17:00
00h15:00
00h16:00
00h10:00
00h16:00
00h15:00
00h11:00
00h12:00
00h23:00
00h18:00
00h12:00
00h15:00
00h10:00
00h19:00

00h31:00

00h18:00
00h18:00
00h17:00
00h30:00

00h19:00
00h47:00
00h20:00
00h30:00
00h30:00
00h35:00
00h26:00
00h26:00

00h14:00

00h19:42

00h26:22

00h15:42

01h56:19
00h17:35

00h11:09
00h11:41
00h10:45
00h09:27
00h18:02
00h13:52
00h10:10
00h13:03
00h16:50
00h09:07
00h23:41
00h16:30
00h14:39
00h11:26
00h08:57
00h15:16
360h14:54
00h08:16
00h11:49
00h00:48
00h00:29
00h26:49
216h22:19
00h00:00
00h00:00
00h25:28
00h20:01
00h06:26
00h13:40
00h13:19
00h26:57
00h10:29
00h10:49
00h12:36
00h16:13

00h14:39
00h21:00
00h20:21
00h15:01

00h13:46
00h31:17
00h18:28
00h10:38
00h15:41
00h18:32
00h12:58
00h15:52
00h09:34

00h33:29

00h56:33

00h10:45

00h12:00

00h18:00
00h08:00

00h14:50

00h21:00

00h17:00
00h17:00

00h14:00
00h16:00
00h15:00
00h16:41

00h45:20
00h13:29
00h15:51
00h42:16
00h12:00
00h11:00
00h06:44
00h16:49
00h44:59
00h08:00
00h09:00
00h49:00
00h18:02

00h06:03
00h27:16
00h30:29

00h09:00
00h12:37
00h15:14
00h43:05
00h12:45
00h18:28
00h12:02
00h13:00
00h10:12

00h12:14

00h11:47

00h09:13
00h10:15

00h11:23
00h11:09
00h11:38
00h11:01
00h07:29
00h10:32
00h08:23
00h12:41
00h19:05
00h11:10

00h12:33

00h12:21
00h13:26
00h12:08
00h08:51
00h15:24

00h10:37

00h24:00

00h32:00
00h18:00
00h15:00

00h14:00
00h20:00
00h15:00

00h18:00

00h17:00

00h14:37

00h11:52

00h31:06
00h23:13
00h16:24
00h14:10
00h18:58
00h21:14
00h21:30

01h25:50
00h21:28
00h59:55

00h18:59
00h14:24
00h12:00
00h13:00
00h14:00
00h14:00
00h09:00
00h14:00
00h07:00
00h15:00
00h11:00
00h15:00
00h07:00
00h09:00
00h10:00
00h13:00
00h13:00
00h09:00
00h09:00

00h05:00
00h11:00
00h09:00
00h11:00
00h11:00
00h06:00

00h08:39
00h07:09
00h17:08
00h11:25
00h12:24
00h08:49
00h13:04

00h20:51

00h17:00

00h12:56

00h17:18
00h17:12
00h18:19
00h12:34
00h13:49

00h17:28
00h39:24

00h17:48
00h07:41

00h25:00
00h20:00

00h13:00

00h11:47
00h12:42

00h21:00

00h11:00
00h11:00
00h49:00
00h13:00
00h11:00

00h07:33

00h10:48
00h20:16
00h19:34

00h10:33
00h17:18
00h17:21
00h24:13
00h20:39
00h13:10

00h08:51

00h11:53
00h18:16

00h27:36

00h42:33

00h14:09

00h11:38

00h24:15
00h13:59
00h12:41
00h16:44
00h22:14
00h10:58
00h24:03
00h10:18
00h09:34
00h15:25
00h10:15
00h09:29
00h06:19
00h43:23
00h17:32
00h09:21

00h07:44
00h11:31
00h07:49
00h07:52
00h10:27
00h06:34
00h56:29

Comment une moyenne totale de 02h26:46 est-elle possible, et comment faire alors?

6 réponses

Réponse 1 / 6
marc07 Messages postés 630 Statut Membre 194
 
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
0
Réponse 2 / 6
RachelMartel Messages postés 460 Statut Membre 25
 
Ce sont probablement ces valeurs qui sont en cause :

216h22:19
360h14:54
0
Réponse 3 / 6
brustus Messages postés 12 Date d'inscription   Statut Membre Dernière intervention  
 
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
0
Réponse 4 / 6
marc07 Messages postés 630 Statut Membre 194
 
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
0

Vous n’avez pas trouvé la réponse que vous recherchez ?

Posez votre question
Réponse 5 / 6
Vaucluse Messages postés 27336 Date d'inscription   Statut Contributeur Dernière intervention   6 453
 
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
0
Réponse 6 / 6
brustus Messages postés 12 Date d'inscription   Statut Membre Dernière intervention  
 
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!!!
0

Discussions similaires

Faire la moyenne de pourcentage sur Excel
Bouchon -
Bouchon -

7 réponses
Supprimer compte Snapchat
Malta -
Alex -

8 réponses
Convertir des heures en mois-jours-heures
akaisii -
akaisii -

14 réponses
convertier de heures en en mois
Chabal -
Mike-31 -

5 réponses
convertir heures de travail en mois
malolita -
Isa -

23 réponses