RSM42

Junior Member

Posts: 1

Average of time

Hi,

Within Excel 2007, I need to calculate the average of the following time values in days, hours, minutes and seconds :

00:18:09:26
00:05:34:50
00:07:41:06
01:22:52:55
00:00:55:48

I've tried using =AVERAGE(A1:A5) and changing the format of the values to various settings, but keep getting DIV/O as the result.

Help ????

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 time	DSN	Excel Discussion (Misc queries)	1	June 4th 10 06:24 AM
Average time	bpc	Excel Worksheet Functions	15	July 14th 08 06:44 PM
Average of Day and Time	Jarod	Excel Worksheet Functions	3	July 11th 08 10:55 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
Average Time	ATP	Excel Worksheet Functions	1	July 20th 05 06:30 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us