Excel Average Hours Issue Solved

Question

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

pijaku · Accepted Answer

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? --

rachid_04 · Answer

Average 1:30 PM; 3:00 PM; 12:15 PM = #DIV0!  I think it's just text  pijaku it works

Mal3kit · Answer

Hello again.

Indeed, when I put all the data in the same format, it works.

New problem: the format does not change automatically! When I select all the cells whose format I need to change, and I modify it, the data is not automatically updated to this format; I have to double-click on each of the cells for the change to take effect...

Is there a way to make this change automatic?

Thank you in advance,

Mal.

rachid_04 · Answer

I think it's a text issue
try this
in another column
cell B2 contains the value: 13h30 (with h)

=REPLACE(B2,3,1," : ")

it should replace the letter h with :

in the end, don't forget to do copy >> special paste >> Values to change the data with H to the data with :

good luck

Mal3kit · Answer

Thank you all for your responses, I finally found it! Let's chalk it up to fatigue...  Best regards, Mal

Excel Average Hours Issue

5 réponses

Saracroche: the effective french app against phone spam

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Black screen digital camera

Connecting rj45 cable with fiber

Sony bravia tv red led blinks 4 times

Free: associating with the freebox server in progress

Inuyasha in french