Posted to microsoft.public.excel.worksheet.functions

Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline

external usenet poster

Posts: 896

Average time

try:

=(SUM(LEFT($E$1:$E$3,LEN($E$1:$E$3)-2)*60+RIGHT($E$1:$E$3,2))/
SUM(IF(LEN($E$1:$E$3)0,1,0)))/60

this will give you time in hrs.000

then format is as time

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
Average of Day and Time	Jarod	Excel Worksheet Functions	3	July 11th 08 10:55 PM
Average Time	Karen	Excel Worksheet Functions	5	September 20th 07 06:19 PM
average rate of change per given time period between 2 moments in time of a value	David Virgil Hobbs	Excel Worksheet Functions	1	December 19th 06 07:24 AM
Finding the average time	Gadgets	Excel Worksheet Functions	5	July 31st 06 09:06 PM
Average Time	ATP	Excel Worksheet Functions	1	July 20th 05 06:30 PM

All times are GMT +1. The time now is 05:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us