如何在Excel 2003中计算平均时间 [英] how to calculate time averge in excel 2003

问题描述

大家好.
如果有人知道如何在excel工作表中计算这些值的平均值.
00:00:00.0768229
00:00:00.0376334
00:00:00.0389140
请让我知道.....
我是这样的:输入average(A1，A2，A3)并按回车键，我就这样:
#DIV/0！..但是我不知道这是什么..

hii to all.
if any body knows how to calculate average of these values in excel sheet.
00:00:00.0768229
00:00:00.0376334
00:00:00.0389140
pls let me know .....
i di like this: enter average(A1,A2,A3)and press enter at that time i got like this:
#DIV/0!..but i don''t know what is this..

推荐答案

try:
=AVERAGE(A1:C1)
我得到的答案是:00:00.1

try :
=AVERAGE(A1:C1)
i got the answer as : 00:00.1

您可以为此使用excel公式

you could use the excel formulas for this

MIN(A1,B1,C1,D1,E1)<br />
<br />
MAX(A1,B1,C1,D1,E1)<br />
<br />
AVERAGE((A1,B1,C1,D1,E1)

假设您要在数据中输入5次时间，则要在其中要显示时间的最小值，最大值和平均值的单元格中显示

您基本上可以将这三个单元格向下拖动到所有用户以复制所有用户的公式


或者您可以参考下面的链接...

http://www.eggheadcafe.com/fileupload/1040266444_MaxLoginTime.jpg [

in the cells where you want to show the min,max and avg of timings assuming you have 5 entries of time in the data

You can just drag the these three cells down to all users basically to copy the formula for all users


or you can refer the link below...

http://www.eggheadcafe.com/fileupload/1040266444_MaxLoginTime.jpg[^]

您也可以使用此...

使用的公式:=SUM(M2:M100)/SUMPRODUCT((M2:M100<>0)*ISNUMBER(M2:M100))

you can also use this...

Formula used: =SUM(M2:M100)/SUMPRODUCT((M2:M100<>0)*ISNUMBER(M2:M100))

这篇关于如何在Excel 2003中计算平均时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！