Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time differences in a column | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions |