#1   Report Post  
ATP
 
Posts: n/a
Default Average Time

I have a column of time values. How do I get the average of all of the times
entered?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=AVERAGE(A2:A100)

and make sure that cell is formatted as time

--
HTH

Bob Phillips

"ATP" wrote in message
...
I have a column of time values. How do I get the average of all of the

times
entered?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to average certain times Denise Excel Discussion (Misc queries) 5 July 18th 05 01:02 PM
How do you calculate average time? G Man Excel Discussion (Misc queries) 4 June 30th 05 07:30 PM
time differences in a column 68magnolia71 Excel Worksheet Functions 3 May 9th 05 09:46 PM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM
Funcation to average the Time spent subbu Excel Worksheet Functions 1 December 7th 04 09:38 AM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"