Averge time

T

tammy

Hi,
I am having a problem with the Avg time, in my A1 column I have Start time,
and A2 column End time, the boss want a avg time on that since I am not
good in fomular in Excel. would you please help.
Thank you very much.
 
P

Peo Sjoblom

=AVERAGE(times)

I don't understand what you mean by A1 and A2 columns

if you in a third column have =end_time - start_time
and the third column would be C1:C5 then use
=AVERAGE(C1:C5)

if you want to average all start times and they are in A1:A5

=AVERAGE(A1:A5)

--
Regards,

Peo Sjoblom

(No private emails please)
 
T

Tammy

Thank you very much.

Peo Sjoblom said:
=AVERAGE(times)

I don't understand what you mean by A1 and A2 columns

if you in a third column have =end_time - start_time
and the third column would be C1:C5 then use
=AVERAGE(C1:C5)

if you want to average all start times and they are in A1:A5

=AVERAGE(A1:A5)

--
Regards,

Peo Sjoblom

(No private emails please)
Click to expand...
 
Top