Posted to microsoft.public.excel.worksheet.functions

Jerry58

external usenet poster

Posts: 5

how to average times in a column

Thank you in advance for the advice! In a worksheet I would like to average a
column of times, the cells are like this:
11:30
11:20
11:17
11:32
11:39
11:10
11:01
etc.
Could someone please help with the formula? Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Need to average clock times	Tall Texan	Excel Worksheet Functions	1	February 5th 08 03:59 PM
average of times	m greenly	Excel Discussion (Misc queries)	4	March 23rd 07 02:37 PM
How do I add a list of times to get an average time?	Matt75	Excel Discussion (Misc queries)	1	January 11th 06 03:07 PM
Formula to average certain times	Denise	Excel Discussion (Misc queries)	5	July 18th 05 01:02 PM
Formula to Average times...again	Denise	Excel Discussion (Misc queries)	1	July 15th 05 08:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us