Tally the figures acquired from the same date

Hi,

I am working on a spreadsheet with electricity meter reading
throughout a year. The reading were taken multiple times on one day.

I tried everything i know to  works out the monthly average of the
electricity usage but i failed.
I managed to flag the day and month on each figure and thats as far as
I go so far.
Can anyone think of a formula to do the task.

An extract of the spreadsheet:

day     Mth    Yr    Time    V_Ave_PC6
9	9	2008	18:00:00	244.3
9	9	2008	18:30:00	243.4
9	9	2008	19:00:00	243.7
9	9	2008	19:30:00	241.9
9	9	2008	20:00:00	242.6
10	9	2008	20:30:00	242.4
10	9	2008	21:00:00	245
10	9	2008	21:30:00	239.8
10	9	2008	22:00:00	242.7

11	9	2008	20:30:00	240.9
11	9	2008	21:00:00	241.8
11	9	2008	21:30:00	241.3
11	9	2008	22:00:00	241.4
11	9	2008	22:30:00	243.7
11	9	2008	23:00:00	241.8
11	9	2008	23:30:00	243.3
11	9	2008	0:00:00	241.4
11	9	2008	0:30:00	242.2
11	9	2008	1:00:00	242.9
11	9	2008	1:30:00	243.1
11	9	2008	2:00:00	244.2 0 9/16/2010 4:22:16 AM excel  39879 articles. 2 followers. 3 Replies 308 Views Similar Articles

[PageSpeed] 6

They look like consumption figures, rather than meter readings (where
the difference gives you the consumption). I think you would need a
helper column where you could combine the day, month and year into a
proper date with this:

=3DDATE(C2,B2,A2)

and then you could get the consumption per day with a SUMIF.

If you just want the consumption for month 9 you could do this:

=3DSUMIF(B:B,9,E:E)

and then divide by the number of days in that month to get the monthly
average usage.

Hope this helps.

Pete

On Sep 16, 5:22=A0am, Brian <lobationt...@gmail.com> wrote:
> Hi,
>
> I am working on a spreadsheet with electricity meter reading
> throughout a year. The reading were taken multiple times on one day.
>
> I tried everything i know to =A0works out the monthly average of the
> electricity usage but i failed.
> I managed to flag the day and month on each figure and thats as far as
> I go so far.
> Can anyone think of a formula to do the task.
>
> An extract of the spreadsheet:
>
> day =A0 =A0 Mth =A0 =A0Yr =A0 =A0Time =A0 =A0V_Ave_PC6
> 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A018:00:00 =A0 =A0 =A0 =A0244.3
> 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A018:30:00 =A0 =A0 =A0 =A0243.4
> 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A019:00:00 =A0 =A0 =A0 =A0243.7
> 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A019:30:00 =A0 =A0 =A0 =A0241.9
> 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A020:00:00 =A0 =A0 =A0 =A0242.6
> 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A020:30:00 =A0 =A0 =A0 =A0242.4
> 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:00:00 =A0 =A0 =A0 =A0245
> 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:30:00 =A0 =A0 =A0 =A0239.8
> 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:00:00 =A0 =A0 =A0 =A0242.7
>
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A020:30:00 =A0 =A0 =A0 =A0240.9
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:00:00 =A0 =A0 =A0 =A0241.8
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:30:00 =A0 =A0 =A0 =A0241.3
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:00:00 =A0 =A0 =A0 =A0241.4
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:30:00 =A0 =A0 =A0 =A0243.7
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A023:00:00 =A0 =A0 =A0 =A0241.8
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A023:30:00 =A0 =A0 =A0 =A0243.3
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A00:00:00 241.4
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A00:30:00 242.2
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A01:00:00 242.9
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A01:30:00 243.1
> 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A02:00:00 244.2 0 9/16/2010 8:45:41 AM
Thx Pete

On Sep 16, 6:45=A0pm, Pete_UK <pashu...@auditel.net> wrote:
> They look like consumption figures, rather than meter readings (where
> the difference gives you the consumption). I think you would need a
> helper column where you could combine the day, month and year into a
> proper date with this:
>
> =3DDATE(C2,B2,A2)
>
> and then you could get the consumption per day with a SUMIF.
>
> If you just want the consumption for month 9 you could do this:
>
> =3DSUMIF(B:B,9,E:E)
>
> and then divide by the number of days in that month to get the monthly
> average usage.
>
> Hope this helps.
>
> Pete
>
> On Sep 16, 5:22=A0am, Brian <lobationt...@gmail.com> wrote:
>
> > Hi,
>
> > I am working on a spreadsheet with electricity meter reading
> > throughout a year. The reading were taken multiple times on one day.
>
> > I tried everything i know to =A0works out the monthly average of the
> > electricity usage but i failed.
> > I managed to flag the day and month on each figure and thats as far as
> > I go so far.
> > Can anyone think of a formula to do the task.
>
> > An extract of the spreadsheet:
>
> > day =A0 =A0 Mth =A0 =A0Yr =A0 =A0Time =A0 =A0V_Ave_PC6
> > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A018:00:00 =A0 =A0 =A0 =A0244.3
> > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A018:30:00 =A0 =A0 =A0 =A0243.4
> > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A019:00:00 =A0 =A0 =A0 =A0243.7
> > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A019:30:00 =A0 =A0 =A0 =A0241.9
> > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A020:00:00 =A0 =A0 =A0 =A0242.6
> > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A020:30:00 =A0 =A0 =A0 =A0242.4
> > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:00:00 =A0 =A0 =A0 =A0245
> > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:30:00 =A0 =A0 =A0 =A0239.8
> > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:00:00 =A0 =A0 =A0 =A0242.7
>
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A020:30:00 =A0 =A0 =A0 =A0240.9
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:00:00 =A0 =A0 =A0 =A0241.8
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:30:00 =A0 =A0 =A0 =A0241.3
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:00:00 =A0 =A0 =A0 =A0241.4
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:30:00 =A0 =A0 =A0 =A0243.7
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A023:00:00 =A0 =A0 =A0 =A0241.8
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A023:30:00 =A0 =A0 =A0 =A0243.3
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A00:00:00 241.4
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A00:30:00 242.2
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A01:00:00 242.9
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A01:30:00 243.1
> > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A02:00:00 244.2

Thx 0 9/17/2010 2:04:52 AM
You're welcome, Brian - thanks for feeding back.

Pete

On Sep 17, 3:04=A0am, Brian <lobationt...@gmail.com> wrote:
> Thx Pete
>
> On Sep 16, 6:45=A0pm, Pete_UK <pashu...@auditel.net> wrote:
>
>
>
>
>
> > They look like consumption figures, rather than meter readings (where
> > the difference gives you the consumption). I think you would need a
> > helper column where you could combine the day, month and year into a
> > proper date with this:
>
> > =3DDATE(C2,B2,A2)
>
> > and then you could get the consumption per day with a SUMIF.
>
> > If you just want the consumption for month 9 you could do this:
>
> > =3DSUMIF(B:B,9,E:E)
>
> > and then divide by the number of days in that month to get the monthly
> > average usage.
>
> > Hope this helps.
>
> > Pete
>
> > On Sep 16, 5:22=A0am, Brian <lobationt...@gmail.com> wrote:
>
> > > Hi,
>
> > > I am working on a spreadsheet with electricity meter reading
> > > throughout a year. The reading were taken multiple times on one day.
>
> > > I tried everything i know to =A0works out the monthly average of the
> > > electricity usage but i failed.
> > > I managed to flag the day and month on each figure and thats as far a=
s
> > > I go so far.
> > > Can anyone think of a formula to do the task.
>
> > > An extract of the spreadsheet:
>
> > > day =A0 =A0 Mth =A0 =A0Yr =A0 =A0Time =A0 =A0V_Ave_PC6
> > > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A018:00:00 =A0 =A0 =A0 =A0244.3
> > > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A018:30:00 =A0 =A0 =A0 =A0243.4
> > > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A019:00:00 =A0 =A0 =A0 =A0243.7
> > > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A019:30:00 =A0 =A0 =A0 =A0241.9
> > > 9 =A0 =A0 =A0 9 =A0 =A0 =A0 2008 =A0 =A020:00:00 =A0 =A0 =A0 =A0242.6
> > > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A020:30:00 =A0 =A0 =A0 =A0242.4
> > > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:00:00 =A0 =A0 =A0 =A0245
> > > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:30:00 =A0 =A0 =A0 =A0239.8
> > > 10 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:00:00 =A0 =A0 =A0 =A0242.7
>
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A020:30:00 =A0 =A0 =A0 =A0240.9
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:00:00 =A0 =A0 =A0 =A0241.8
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A021:30:00 =A0 =A0 =A0 =A0241.3
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:00:00 =A0 =A0 =A0 =A0241.4
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A022:30:00 =A0 =A0 =A0 =A0243.7
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A023:00:00 =A0 =A0 =A0 =A0241.8
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A023:30:00 =A0 =A0 =A0 =A0243.3
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A00:00:00 241.4
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A00:30:00 242.2
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A01:00:00 242.9
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A01:30:00 243.1
> > > 11 =A0 =A0 =A09 =A0 =A0 =A0 2008 =A0 =A02:00:00 244.2
>
> Thx- Hide quoted text -
>
> - Show quoted text - 0 9/17/2010 8:28:14 AM Similar Artilces:

Date/Time in different languages
Dear people, I have a facility in my program to set the date and time format according to the user's preferences. To do so, I run this command: ShellExecute(NULL,_T("open"),_T("rundll32.exe"), _T("shell32.dll Control_RunDLL timedate.cpl"), NULL,SW_SHOW) ; whichs presents a system dialog where the user can select anything he needs. My problem: The dialog is always shown in the operating system's language. But I'd like to show it in other languages, too. Is this dialog available at all in other languages? And if yes, how do I launch it? ...

Sorting Dates
I have a query with a 'date' column. In this column, I have dates from 7/27/2007 - 8/12/2007. When I sort the dates, it goes from 7/27 - 8/1. Then it goes 8/10 - 8/12, and from 8/2 - 8-9. What can I do to get this thing to sort correctly? The problem is that your dates are not dates, they are text strings. Try adding a calculated column and then sorting by that column Field: RealDate: DateValue([YourField] & "/2007") -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County .. &quo...

Associate date format with account
I have a couple of English bank accounts and when I download data from them to load into Money, it has a nasty habit of assuming that the dates were in American format (MM/DD/YYYY) rather than English (DD/MM/YYYY). Please allow this to be configured on the account if it differs from normal. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-ba...

Figures to words
Can we convert figures like 5000 to words as Five Thousands in Excel by any means -- Sanjay Jain Gurgaon Haryana India Hi see: http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Regards Frank Kabel Frankfurt, Germany "jain_sanju" <jain_sanju@hotmail.com> schrieb im Newsbeitrag news:41D2B11B-5B25-424A-9BE7-B8D53A298398@microsoft.com... > Can we convert figures like 5000 to words as Five Thousands in Excel by any > means > -- > Sanjay Jain > Gurgaon > Haryana > India ...

Date parameters won't work on crosstab report
I have queries and reports that show our quotes by lead source. I use date parameters to filter the "QuoteDate" range on which to report. However this doesn't work on a crosstab query or a crosstab report. My row heading is Lead Source (e.g. Yellow Pages, Recommendation, etc etc). My column heading is Status (e.g. Booked, Lost, Pending etc) The values of our quotes are displayed accordingly, no problem. On a regular Select Query or a basic Report, the date filter works fine. However, on a Crosstab Query, if I enter StartDate and EndDate (Date/Time) in the Query/Parameters windo...

Subtotal by date shows US format rather than other way round
I have a spreadsheet which has data subtotalled by date. My date format is dd/mm/yyyy, but the subtotals show mm/dd/yyyy. When I look in 'format cell' it shows my format is dd/mm/yyy, but even still it shows the other way around. How do I fix this? ...

Query to extract data on the basis of date
hi, I have created a query to extract the details of data on the basis of date in the table. The problem is the query is not giving the correct details. Can you pls let me know how to solve this problem? Thanks in Advance for the help!!!! Regards, Karthik.... Hi Karthik, I'm sure you know exactly what result you want, based on your data, but keep in mind that no one else has this benefit. You will need to explain in more detail what your problem is, if you have any hope of getting your question answered here. Is the date in your table stored in a Date/Time data type, or in a tex...

Date Fields Comparison
I WILL LIKE TO COMPARE TWO DATE FIELDS IN A ROW AND SELECT THE CELL WITH THE GREATEST NUMBER OF DAYS IN THE MONTH FOR THE ROW. WHA FORMULA WILL ENABLE ME TO ACHIEVE THIS , PLEASE. THE ROW IN QUESTIO IS ABOUT 5000 SEE EXAMPLE BELOW. DATE 1 DATE 2 RESULT EXPECTED 08/04/04 09/05/04 08/04/04 01/04/04 30/04/04 30/04/0 -- Message posted from http://www.ExcelForum.com Hi first: please turn-off your CAPS Lock: Makes it difficult to read For your question: Why did you choose 08/04/04 in the first row? Date 2 has 9 days? -- Regards Frank Kabel Frank...

Converting dates to fiscal quarters
Is there a way to easily convert a date to a fiscal quarter Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-199 Thanks in advance for your respons One way with the date in A1 ="Q"&INT((MONTH(A1)+2)/3)&" - "&TEXT(YEAR(A1),"@") -- Regards, Peo Sjoblom "James" <anonymous@discussions.microsoft.com> wrote in message news:9F45345C-B1DB-4353-8292-A216A88121A3@microsoft.com... > Is there a way to easily convert a date to a fiscal quarter? > Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-1998 > > Thanks in advance for your res...

No days, only dates
When I view the calendar in Week mode it displays the dates, but not the days of the week. Of course, in time you will get used to it and don't need to count round from Monday to Sunday, but it would be nice if the day was next to the date on top of each box. Is there an option for that? Thank you That is a long date format setting. If you use days in the long date, you'll see them on the calendar. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Outlook Tips by email: dailytips-...

How do I put tally counts in Excel?
Just a tad more detail wouldn't go amiss here. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "KK" <KK@discussions.microsoft.com> wrote in message news:7C779983-96D6-4ED1-A0F0-70D9E39EB3AE@microsoft.com... > Care to explain in the body of the message what ...

Problem Date Formatting
Hi, I'm having a problem changing the formatting of a cell to a date format. I have changed the format of the cell to date... however, when a date is entered into the cell an = apperars in front of it in the formula bar and the result in the cell is 00-01-00. Can anyone suggest what is going on? Thanks in advance Alan Make sure that in the tools options transition that lotus 1-2-3 has not been checked. What is happening is you are dividing the day by the month by the year which will evaluate as something less than one, and as the Excel Calendar starts from Jan 1st 1900 a valu...

i want to select a date in calander
I want to select a date in excel 2007 that date has to appeare in desired cell this how is possible EggHeadCafe - Software Developer Portal of Choice C# MSMQ - Send and Receive XML http://www.eggheadcafe.com/tutorials/aspnet/af86b2ae-f9b9-4f29-a08b-9332ed9da498/c-msmq--send-and-receiv.aspx Check it here http://www.fontstuff.com/vba/vbatut07.htm On Nov 19, 10:25=A0am, jai krishnan wrote: > I want to select a date in excel 2007 that date has to appeare in desired= cell > this how is possible > > EggHeadCafe - Software Developer Portal of Choice > C# MSMQ -...

Tracking "Date Last Saved"
I am trying to show on the page (footer would be ok) the date that a spreadsheet was last modified. The footer only allows input of the current date and time. I want something that shows when someone made changes to a spreadsheet, not just viewed it. Basically need the info in the "Properties" section to show up on the page. Any ideas? Thanks!! Hi if you want to insert the last save date in your header/footer insert the following code in your workbook module Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim wkSht As Worksheet For Each wkSht In Me.Worksheets ...

Querying Dates
Hello, I am looking for some advice on how to tackle querying some data. I have two tables, table one with around 10,000 records per month and columns that give me (for each record) a start date, start time, end date and end time. Table two details a percentage for each hour and day of the week (so 24 hours * 7 days = 168 records). This has three columns, the day of the week (Mon to Sun), the hour (00:00 to 23:00) and a percentage. What I want to do is sum the total of the percentage column in table 2 where the day of the week and the hour of the week fall within the st...

How can I figure square footage for 2 or 3 numbers in a row?
I need to figure square footage of 2 dimensions, height, width, , leaving out a thrid number in the same cell, then multiply by a separate number. Any way to do that? Post a sample of your dimensions. You might be able to do that with LEFT(), MID() and RIGHT()...? A looong shot guess would be something like this: =LEFT(F1,1)*MID(F1,3,1)*H1 Where your 3 numbers in F1 are 2x5x10, and H1 has the number 8, which you want to multiply by. Returns 80. Falls apart with two-digit dimensions or a combo of one and two! HTH Regards, Howard "Sandi" <Sandi@disc...

Subreport link by Date field
Hello, I have an Access 2003 report with a subreport. The main report has a column for customerID and Date, I want the subreport to show any records from another table that occurs after the Date on the main record. Can I use the Link Child Field and Link Master Field for this? I know I can put "CustomerID;Date" in these fields but that would give me results that have an exact date match. Thanks Try using CustomerID in the links and Date criteria from main form in query for the sub. -- Build a little, test a little. "Don" wrote: > Hello, ...

Date format in Receipts
Hello: My boss wants to add the Due Date on each receipt that uses Account as tender. I created the variable on XML code using: <SET name="DueDate" type="vbDate"> Transaction.Date + 20 </SET> And print it with: <IF> <CONDITION> (Tender.Descriptor.TenderType = tenderAccount)</CONDITION> <THEN> <ROW> "Due Date|" DueDate </ROW> </THEN> </IF> This works, but the DueDate is printed as a number. How can I change its format to MM/DD/YYYY. I tried using all VB Date function, but no one worked. Please, hel...

Change Date Format Within E-mail
While using the E-mail Template Manager, I notice the date format that comes in from the database is 2005-01- 12T00:00:00-05:00. I'm assuming this is GMT format. I would like to have this format modified to 12/01/2005. Is this possible? Please help ... This option is not available currently out of the box. Frank Lee Workopia, Inc. http://www.workopia.com/Links.htm San Francisco, CA "Jeff" wrote: > While using the E-mail Template Manager, I notice the > date format that comes in from the database is 2005-01- > 12T00:00:00-05:00. I'm assuming this is GMT f...

Add a date to a form
I am wanting to add a CreateDate to a form which enters the date from the computer system but doesn't update the next day. Any helpers please! Thanks Alastair I'm assuming you mean you want the CreateDate to be on a field in a table. Simply putting a date on a form doesn't buy you much... Set the field's DefaultValue to Date() (assuming all you want is the date), or Now() (if you want both date and time). Whenever a new row is added to the table, the field will pick up the default value. The Default Value will have no effect on existing rows. -- Doug Steele, Microso...

Timer, Tally, and Count
I am trying to expiriment with using excel to design and layout a factory. I don't know if I can get Excel to do what I want but here goes. I would like to designate a cell as a station in a factory set a certain time that station uses to "make a product" then have that cell "send" its part to another cell named travel for an amount of time then to the next station in the factory. for ex. Cell A1 is Welding, welding takes 5hrs to do a job and then it sends its parts to Cell B1 is travel, travel takes 5min to get to the next step which is Cell C1 Paint, Paint takes ...

Removal Date
Dear Experts, Please help for the following condition: 1. I have one sheet "A" which contain of database, the field structure as follows: Field A = Date Field B = SN Filed C ... I have a lot of records, which can contains the same SN (Serial Number) but with different Removal Date. 2. on the other worksheet...i create the following field COL A = SN COL B = First Removal Date COL C = Second Removal Date. COL D = Third Removal Date. Please guide to which function i should use? As i use VLOOKUP, it will be go the first occurance of the date removal...(the...

Switch X & Y axis' when both data columns are dates (target/actual
I am plotting Target vs Actual completion dates for a project management S-Curve, using Excel. Since both data columns are "dates", Excel wants to use "dates" on the Value Axis (Y), while putting the Task #s on the X axis. How do I switch axis' so that time runs horizontally on the X axis, with the Task #s on the Y? Thanks Chart menu > Source Data > Series tab: change what's in the edit boxes for X and Y. You could try this utility: http://peltiertech.com/Excel/Charts/axes.html#SwitchXY - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Cust...

Convert a Date to a Day
Is it possible to have a reference date in Cell A1 - say 19/04/2005 and Return a value in Cell B1 - Tuesday ?. I've tried =DAY(A1) but it returns 19 Thanks try =text(a1,"dddd") -- Don Guillett SalesAid Software donaldb@281.com "John" <john@yahoooo.co> wrote in message news:CA69e.51802\$Z14.40878@news.indigo.ie... > Is it possible to have a reference date in Cell A1 - say 19/04/2005 and > Return a value in Cell B1 - Tuesday ?. I've tried =DAY(A1) but it returns 19 > > > Thanks > > > Thanks Don "Don Guillett" <don...

Remove "Date: Yesterday" or "Date: Monday" from Outlook Inbox?
Outlook mail inbox now has headers that tell you what day the the email was sent. I find this visually annoying. Each emailalready has the time and day it was sent. I don't need the daily titles in the midst of the list of emails. How do I make them go away? I think you are talking about OL 2003 & the Arrange in Groups setting. Change it in View, Arrange by, uncheck Show in Groups. "silky" wrote: > Outlook mail inbox now has headers that tell you what day the the email was > sent. I find this visually annoying. Each emailalready has the time and day >...