Forum Discussion

Brass Contributor

Sep 11, 2020

Need help to calculate average value on timestamps

Hello i'm new to excel! I need some help, i'm trying to calculate the average time of the timestamps in the column "Tider" but it doesnt work. It only gives me "#Division/0!" Medel means Average ...

excel

Formulas and Functions

Bennadeau

Iron Contributor

Sep 17, 2020

Hi 288088,

How are your cells formatted in column A?

I tried with hh:mm:ss and it seems to be working fine.

Then using this formula, I got an average.

=AVERAGE(A2:A41)

My knowledge of "medel" is none existent (I'm actually assuming "medel" is Swedish or maybe German. Am I close?) so I can't really comment on your current formula.