Posted to microsoft.public.excel.worksheet.functions

Hookette

external usenet poster

Posts: 5

Averaging

If I have a column of data that I got using this formula:

DATEDIF(B2,C2,"m") & " months " & DATEDIF(B2,C2,"md") & " days " &
TEXT(C2-B2,"hh") & " hours " & LEFT(TEXT(C2-B2,"mm:ss"),2) & " minutes"

is there any way to then get an average from that column. When I used the
regular average function that didn't work.

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
Averaging	JRD	Excel Worksheet Functions	2	December 11th 07 08:36 PM
averaging	belvy123	Excel Discussion (Misc queries)	1	April 26th 07 11:34 AM
Help with averaging...	lherndo	Excel Discussion (Misc queries)	2	April 5th 06 02:54 PM
Averaging	waterwayz	Excel Discussion (Misc queries)	5	July 11th 05 04:09 PM
Averaging	GWit	Excel Discussion (Misc queries)	1	May 29th 05 02:46 AM

All times are GMT +1. The time now is 09:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us