Averge time
 

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.

=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)


"tammy" wrote in message
...
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.

Thank you very much.

"Peo Sjoblom" wrote:

=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)


"tammy" wrote in message
...
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.