View original (French)

Excel Average Hours Issue

Solved
Mal3kit Posted messages 9 Status Member -  
Mal3kit Posted messages 9 Status Member -
Hello, I need to calculate the average of hours in Excel. The problem is that Excel does not take into account the hour format of my cells and systematically divides the number of hours by the number of minutes. For example:

Average 13h30; 15:00; 12h15 = #DIV0!

Do you have a solution?

Thank you in advance,

Mal.

Configuration: Windows XP / Internet Explorer 6.0

5 answers

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
     
    Hello,
    By having the same format in all my cells containing times, I get a result...
    Example:
    A1: 13:30, A2: 15:00, A3: 12:15
    A4: =AVERAGE(A1:A3) gives me 13:35 as the result
    Best regards,
    -- Every problem has its solution. If there is no solution, then where is the problem? --
    6