Forum Discussion
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 ...
Most probably you have not time (which is form of number), but texts which represents number. AVERAGE() of texts returns division on zero error since function ignores all texts in the range and there is no one number. Thus you calculate average of nothing.
Please use double dash to convert texts to numbers (time)
=AVERAGE(--A2:A42)