average if with time and date

freedom21

New Member

Join Date: Nov 2010

Posts: 1

18th Nov 2010

average if with time and date

Hi all

I have file with temperature values for the period of a month and temperature recorded every 10 minutes. I have to calcutate the average day and night temperature for all the period. The dataset look like this

date time temperature
8-5-2010 00:00:00 12.1
8-5-2010 00:10:00 12.4
8-5-2010 00:20:00 12.3
.
.
.
.
8-5-2010 23:40:00 12
8-5-2010 23:50:00 11.7

Any idea how to do it?It is fine if I ll get the answer for english excell but the danish version would appreciate also.

thanks

« Excel 2007 Tracing dependents | HELP! Split cell contents to new rows »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average time from date column?	GWB	Microsoft Access Queries	9	14th Apr 2010 04:54 PM
Average time from date time column?	GWB	Microsoft Access	3	12th Apr 2010 08:08 PM
date/time average	Hookette	Microsoft Excel Worksheet Functions	2	9th Sep 2009 06:48 PM
Date/Time Average??	=?Utf-8?B?YmxhZGVsb2Nr?=	Microsoft Access Reports	7	10th Nov 2005 06:03 AM
date time average	Pam	Microsoft Excel Worksheet Functions	2	10th Feb 2004 05:48 PM