Posted to microsoft.public.excel.worksheet.functions

EÃ¡n[_2_]

external usenet poster

Posts: 30

Calculating Average Time

Hi

I have two columns one with a number of occurances and the other with a
duration of time hh:mm - formatted by /24/60.
I need to find a formula so I can show in a third column the average time
per occurance, so for example:

2 00:20
5 01:00

So the third column would show 00:10 and 00:20 respectively.

Many 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
Calculating an average	Maggie	Excel Worksheet Functions	1	August 22nd 08 03:50 AM
Calculating Average	ub	Excel Discussion (Misc queries)	2	July 16th 08 05:14 PM
Calculating Average	Graham	Excel Worksheet Functions	1	July 2nd 08 04:40 PM
Calculating the average	Andy_Trow	Excel Discussion (Misc queries)	3	July 27th 07 02:15 PM
calculating moving average	[email protected]	Excel Worksheet Functions	1	May 14th 06 11:13 AM

All times are GMT +1. The time now is 10:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us