Start Time & End Time

I have a table of data for my Scheduled cutting list that is exported
from another program into an Excel Spreadsheet and from this table I
would like to be able to find the start and end time of the production
runs automatically in a separate table.

The table is set up like this

Planned order   Time               Product Description     Volume
12345              08:00:00          Product 1
3500
23435              11:32:00          Product 2                   5680
14567              13:24:00          Product 3                   10000

and so on.

I can find the start time by using Vlookup( Planned order,Datatable,
2,false) which returns 08:00:00. The end time of Product 1 is the
start time of the next planned order for Product 2 etc etc

What I would like is a table that looks like this:

Planned order     Start time     End time       Volume
12345                08:00:00      11:32:00           3500
23435                11:32:00      13:24:00           5680
14567                13:24:00      22:00:00           10000

I hope I've explained this ok

Regards

Pete

0
Pete
11/13/2009 10:07:50 AM
excel.newusers 15348 articles. 2 followers. Follow

7 Replies
1544 Views

Similar Articles

[PageSpeed] 50

Hi Pete,

What you would be best to use is an array formula. When you enter an
array formula, you press Ctrl+Shift+Enter instead of just Enter. (Some
people call them CSE formulas because of this key combo).

I won't go too deep into specifics of how they work as there are much
better people and websites to check out.

The formula you would enter is:

=3DMIN(IF($H$2:$H$5>H2,$H$2:$H$5,""))

Where Column H has your start times and H2 is the start time of the
current order. After you press Ctrl+Shift+Enter, it will show curly
braces around it:

{=3DMIN(IF($H$2:$H$5>H2,$H$2:$H$5,""))}

The array formula works by calculating each cell of the array
separately. So the IF statement is like having this instead:

If ($H$2>H2,$H$2,"")
If ($H$3>H2,$H$3,"")
If ($H$4>H2,$H$4,"")
If ($H$5>H2,$H$5,"")

It then takes the result of that IF statement (either the cell value,
or "") and finds the minumum (lowest) number. This is the next time in
the series.

This will work for you only if there is no crossing over to the next
day. That would require storing dates as well as times, but the
formula should still work.

Happy to send you the workbook that I used to work on this if you
would like an example. Drop me an email with:

The USENET Group Name AND the Subject Header in the subject line
Your Email Address
A copy of your original post.

Cheers,
Nick



Then the MIN formula finds the lowest time (earliest) from the
remaining ones.

This is ok if you are only looking at say one machine. If you have
multiple machines then you would need separate tables for each one.
There might be better solutions - anyone?



On Nov 13, 8:07=A0pm, Pete <fell-wal...@hotmail.co.uk> wrote:
> I have a table of data for my Scheduled cutting list that is exported
> from another program into an Excel Spreadsheet and from this table I
> would like to be able to find the start and end time of the production
> runs automatically in a separate table.
>
> The table is set up like this
>
> Planned order =A0 Time =A0 =A0 =A0 =A0 =A0 =A0 =A0 Product Description =
=A0 =A0 Volume
> 12345 =A0 =A0 =A0 =A0 =A0 =A0 =A008:00:00 =A0 =A0 =A0 =A0 =A0Product 1
> 3500
> 23435 =A0 =A0 =A0 =A0 =A0 =A0 =A011:32:00 =A0 =A0 =A0 =A0 =A0Product 2 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 5680
> 14567 =A0 =A0 =A0 =A0 =A0 =A0 =A013:24:00 =A0 =A0 =A0 =A0 =A0Product 3 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 10000
>
> and so on.
>
> I can find the start time by using Vlookup( Planned order,Datatable,
> 2,false) which returns 08:00:00. The end time of Product 1 is the
> start time of the next planned order for Product 2 etc etc
>
> What I would like is a table that looks like this:
>
> Planned order =A0 =A0 Start time =A0 =A0 End time =A0 =A0 =A0 Volume
> 12345 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A008:00:00 =A0 =A0 =A011:32:00 =A0 =A0=
 =A0 =A0 =A0 3500
> 23435 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A011:32:00 =A0 =A0 =A013:24:00 =A0 =A0=
 =A0 =A0 =A0 5680
> 14567 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A013:24:00 =A0 =A0 =A022:00:00 =A0 =A0=
 =A0 =A0 =A0 10000
>
> I hope I've explained this ok
>
> Regards
>
> Pete

0
Nicholas
11/13/2009 10:49:18 AM
Hi Pete,

What you would be best to use is an array formula. When you enter an
array formula, you press Ctrl+Shift+Enter instead of just Enter. (Some
people call them CSE formulas because of this key combo).

I won't go too deep into specifics of how they work as there are much
better people and websites to check out.

The formula you would enter is:

=MIN(IF($H$2:$H$5>H2,$H$2:$H$5,""))

Where Column H has your start times and H2 is the start time of the
current order. After you press Ctrl+Shift+Enter, it will show curly
braces around it:

{=MIN(IF($H$2:$H$5>H2,$H$2:$H$5,""))}

The array formula works by calculating each cell of the array
separately. So the IF statement is like having this instead:

If ($H$2>H2,$H$2,"")
If ($H$3>H2,$H$3,"")
If ($H$4>H2,$H$4,"")
If ($H$5>H2,$H$5,"")

It then takes the result of that IF statement (either the cell value,
or "") and finds the minumum (lowest) number. This is the next time in
the series.

This will work for you only if there is no crossing over to the next
day. That would require storing dates as well as times, but the
formula should still work.


Happy to send you the workbook that I used to work on this if you
would like an example. Drop me an email with:

The USENET Group Name AND the Subject Header in the subject line
Your Email Address
A copy of your original post.

Cheers,
Nick

"Pete" wrote:

> I have a table of data for my Scheduled cutting list that is exported
> from another program into an Excel Spreadsheet and from this table I
> would like to be able to find the start and end time of the production
> runs automatically in a separate table.
> 
> The table is set up like this
> 
> Planned order   Time               Product Description     Volume
> 12345              08:00:00          Product 1
> 3500
> 23435              11:32:00          Product 2                   5680
> 14567              13:24:00          Product 3                   10000
> 
> and so on.
> 
> I can find the start time by using Vlookup( Planned order,Datatable,
> 2,false) which returns 08:00:00. The end time of Product 1 is the
> start time of the next planned order for Product 2 etc etc
> 
> What I would like is a table that looks like this:
> 
> Planned order     Start time     End time       Volume
> 12345                08:00:00      11:32:00           3500
> 23435                11:32:00      13:24:00           5680
> 14567                13:24:00      22:00:00           10000
> 
> I hope I've explained this ok
> 
> Regards
> 
> Pete
> 
> .
> 
0
Utf
11/13/2009 11:01:01 AM
Hi Again Pete,

Sorry my email is nicholas@nicholasperkins.com.

Cheers,
Nicholas Perkins
nicholas@nicholasperkins.com
http://www.nicholasperkins.com/blog/

"Pete" wrote:

> I have a table of data for my Scheduled cutting list that is exported
> from another program into an Excel Spreadsheet and from this table I
> would like to be able to find the start and end time of the production
> runs automatically in a separate table.
> 
> The table is set up like this
> 
> Planned order   Time               Product Description     Volume
> 12345              08:00:00          Product 1
> 3500
> 23435              11:32:00          Product 2                   5680
> 14567              13:24:00          Product 3                   10000
> 
> and so on.
> 
> I can find the start time by using Vlookup( Planned order,Datatable,
> 2,false) which returns 08:00:00. The end time of Product 1 is the
> start time of the next planned order for Product 2 etc etc
> 
> What I would like is a table that looks like this:
> 
> Planned order     Start time     End time       Volume
> 12345                08:00:00      11:32:00           3500
> 23435                11:32:00      13:24:00           5680
> 14567                13:24:00      22:00:00           10000
> 
> I hope I've explained this ok
> 
> Regards
> 
> Pete
> 
> .
> 
0
Utf
11/13/2009 11:06:01 AM
On Fri, 13 Nov 2009 02:07:50 -0800 (PST), Pete <fell-walker@hotmail.co.uk>
wrote:

>I have a table of data for my Scheduled cutting list that is exported
>from another program into an Excel Spreadsheet and from this table I
>would like to be able to find the start and end time of the production
>runs automatically in a separate table.
>
>The table is set up like this
>
>Planned order   Time               Product Description     Volume
>12345              08:00:00          Product 1
>3500
>23435              11:32:00          Product 2                   5680
>14567              13:24:00          Product 3                   10000
>
>and so on.
>
>I can find the start time by using Vlookup( Planned order,Datatable,
>2,false) which returns 08:00:00. The end time of Product 1 is the
>start time of the next planned order for Product 2 etc etc
>
>What I would like is a table that looks like this:
>
>Planned order     Start time     End time       Volume
>12345                08:00:00      11:32:00           3500
>23435                11:32:00      13:24:00           5680
>14567                13:24:00      22:00:00           10000
>
>I hope I've explained this ok
>
>Regards
>
>Pete

The "best" formulas depend on whether you are working with Excel 2007+ or
earlier versions.  2007+ has the IFERROR function, and earlier versions do not.

I used NAME'd ranges for the variables.  You can either NAME the ranges, or use
cell references.

I don't know how you determine the End Time of the last entry; so in your
example, the formula will return a #NUM! error.  This can be altered depending
on your specifics.

There is error checking so as to return blanks for entries that are not
present.

Here are the formulas:

Planned Order:
	Excel 2007+:
	  =IFERROR(INDEX(Planned_order,MATCH(Start_Time,Time,0)),"")

	Excel 2003 and earlier:
=IF(ISNA(INDEX(Planned_order,MATCH(Start_Time,Time,0))),
"",INDEX(Planned_order,MATCH(Start_Time,Time,0)))

Start Time:
=IF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:1)))

End Time:
=IF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:2)))

Product Description:
	Excel 2007+
=IFERROR(INDEX(Product_Description,MATCH(Start_Time,Time,0)),"")

	Excel 2003 and earlier:
=IF(ISNA(INDEX(Product_Description,MATCH(Start_Time,Time,0))),
"",INDEX(Product_Description,MATCH(Start_Time,Time,0)))

Volume:
	Excel 2007+:
=IFERROR(IF(INDEX(Volume,MATCH(Start_Time,Time,0))=0,
"",INDEX(Volume,MATCH(Start_Time,Time,0))),"")

	Excel 2003 and earlier
=IF(Start_Time="","",IF(INDEX(Volume,MATCH(Start_Time,Time,0))=0,
"",INDEX(Volume,MATCH(Start_Time,Time,0))))
--ron
0
Ron
11/13/2009 11:41:42 AM
On Fri, 13 Nov 2009 06:41:42 -0500, Ron Rosenfeld <ronrosenfeld@nospam.org>
wrote:

>On Fri, 13 Nov 2009 02:07:50 -0800 (PST), Pete <fell-walker@hotmail.co.uk>
>wrote:
>
>>I have a table of data for my Scheduled cutting list that is exported
>>from another program into an Excel Spreadsheet and from this table I
>>would like to be able to find the start and end time of the production
>>runs automatically in a separate table.
>>
>>The table is set up like this
>>
>>Planned order   Time               Product Description     Volume
>>12345              08:00:00          Product 1
>>3500
>>23435              11:32:00          Product 2                   5680
>>14567              13:24:00          Product 3                   10000
>>
>>and so on.
>>
>>I can find the start time by using Vlookup( Planned order,Datatable,
>>2,false) which returns 08:00:00. The end time of Product 1 is the
>>start time of the next planned order for Product 2 etc etc
>>
>>What I would like is a table that looks like this:
>>
>>Planned order     Start time     End time       Volume
>>12345                08:00:00      11:32:00           3500
>>23435                11:32:00      13:24:00           5680
>>14567                13:24:00      22:00:00           10000
>>
>>I hope I've explained this ok
>>
>>Regards
>>
>>Pete
>
>The "best" formulas depend on whether you are working with Excel 2007+ or
>earlier versions.  2007+ has the IFERROR function, and earlier versions do not.
>
>I used NAME'd ranges for the variables.  You can either NAME the ranges, or use
>cell references.
>
>I don't know how you determine the End Time of the last entry; so in your
>example, the formula will return a #NUM! error.  This can be altered depending
>on your specifics.
>
>There is error checking so as to return blanks for entries that are not
>present.
>
>Here are the formulas:
>
>Planned Order:
>	Excel 2007+:
>	  =IFERROR(INDEX(Planned_order,MATCH(Start_Time,Time,0)),"")
>
>	Excel 2003 and earlier:
>=IF(ISNA(INDEX(Planned_order,MATCH(Start_Time,Time,0))),
>"",INDEX(Planned_order,MATCH(Start_Time,Time,0)))
>
>Start Time:
>=IF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:1)))
>
>End Time:
>=IF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:2)))
>
>Product Description:
>	Excel 2007+
>=IFERROR(INDEX(Product_Description,MATCH(Start_Time,Time,0)),"")
>
>	Excel 2003 and earlier:
>=IF(ISNA(INDEX(Product_Description,MATCH(Start_Time,Time,0))),
>"",INDEX(Product_Description,MATCH(Start_Time,Time,0)))
>
>Volume:
>	Excel 2007+:
>=IFERROR(IF(INDEX(Volume,MATCH(Start_Time,Time,0))=0,
>"",INDEX(Volume,MATCH(Start_Time,Time,0))),"")
>
>	Excel 2003 and earlier
>=IF(Start_Time="","",IF(INDEX(Volume,MATCH(Start_Time,Time,0))=0,
>"",INDEX(Volume,MATCH(Start_Time,Time,0))))
>--ron

I forgot to write that you enter the above formulas in columns in the first
row; then select them all and copy/drag (fill) down as far as required (or
until you start seeing blanks in the Start_time column).

Also, you will need to format the Start Time and End Time columns as Time.
--ron
0
Ron
11/13/2009 2:03:57 PM
On Nov 13, 2:03=A0pm, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
> On Fri, 13 Nov 2009 06:41:42 -0500, Ron Rosenfeld <ronrosenf...@nospam.or=
g>
> wrote:
>
>
>
>
>
> >On Fri, 13 Nov 2009 02:07:50 -0800 (PST), Pete <fell-wal...@hotmail.co.u=
k>
> >wrote:
>
> >>I have a table of data for my Scheduled cutting list that is exported
> >>from another program into an Excel Spreadsheet and from this table I
> >>would like to be able to find the start and end time of the production
> >>runs automatically in a separate table.
>
> >>The table is set up like this
>
> >>Planned order =A0 Time =A0 =A0 =A0 =A0 =A0 =A0 =A0 Product Description =
=A0 =A0 Volume
> >>12345 =A0 =A0 =A0 =A0 =A0 =A0 =A008:00:00 =A0 =A0 =A0 =A0 =A0Product 1
> >>3500
> >>23435 =A0 =A0 =A0 =A0 =A0 =A0 =A011:32:00 =A0 =A0 =A0 =A0 =A0Product 2 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 5680
> >>14567 =A0 =A0 =A0 =A0 =A0 =A0 =A013:24:00 =A0 =A0 =A0 =A0 =A0Product 3 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 10000
>
> >>and so on.
>
> >>I can find the start time by using Vlookup( Planned order,Datatable,
> >>2,false) which returns 08:00:00. The end time of Product 1 is the
> >>start time of the next planned order for Product 2 etc etc
>
> >>What I would like is a table that looks like this:
>
> >>Planned order =A0 =A0 Start time =A0 =A0 End time =A0 =A0 =A0 Volume
> >>12345 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A008:00:00 =A0 =A0 =A011:32:00 =A0 =
=A0 =A0 =A0 =A0 3500
> >>23435 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A011:32:00 =A0 =A0 =A013:24:00 =A0 =
=A0 =A0 =A0 =A0 5680
> >>14567 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A013:24:00 =A0 =A0 =A022:00:00 =A0 =
=A0 =A0 =A0 =A0 10000
>
> >>I hope I've explained this ok
>
> >>Regards
>
> >>Pete
>
> >The "best" formulas depend on whether you are working with Excel 2007+ o=
r
> >earlier versions. =A02007+ has the IFERROR function, and earlier version=
s do not.
>
> >I used NAME'd ranges for the variables. =A0You can either NAME the range=
s, or use
> >cell references.
>
> >I don't know how you determine the End Time of the last entry; so in you=
r
> >example, the formula will return a #NUM! error. =A0This can be altered d=
epending
> >on your specifics.
>
> >There is error checking so as to return blanks for entries that are not
> >present.
>
> >Here are the formulas:
>
> >Planned Order:
> > =A0 =A0Excel 2007+:
> > =A0 =A0 =A0=3DIFERROR(INDEX(Planned_order,MATCH(Start_Time,Time,0)),"")
>
> > =A0 =A0Excel 2003 and earlier:
> >=3DIF(ISNA(INDEX(Planned_order,MATCH(Start_Time,Time,0))),
> >"",INDEX(Planned_order,MATCH(Start_Time,Time,0)))
>
> >Start Time:
> >=3DIF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:1)))
>
> >End Time:
> >=3DIF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:2)))
>
> >Product Description:
> > =A0 =A0Excel 2007+
> >=3DIFERROR(INDEX(Product_Description,MATCH(Start_Time,Time,0)),"")
>
> > =A0 =A0Excel 2003 and earlier:
> >=3DIF(ISNA(INDEX(Product_Description,MATCH(Start_Time,Time,0))),
> >"",INDEX(Product_Description,MATCH(Start_Time,Time,0)))
>
> >Volume:
> > =A0 =A0Excel 2007+:
> >=3DIFERROR(IF(INDEX(Volume,MATCH(Start_Time,Time,0))=3D0,
> >"",INDEX(Volume,MATCH(Start_Time,Time,0))),"")
>
> > =A0 =A0Excel 2003 and earlier
> >=3DIF(Start_Time=3D"","",IF(INDEX(Volume,MATCH(Start_Time,Time,0))=3D0,
> >"",INDEX(Volume,MATCH(Start_Time,Time,0))))
> >--ron
>
> I forgot to write that you enter the above formulas in columns in the fir=
st
> row; then select them all and copy/drag (fill) down as far as required (o=
r
> until you start seeing blanks in the Start_time column).
>
> Also, you will need to format the Start Time and End Time columns as Time=
..
> --ron- Hide quoted text -
>
> - Show quoted text -

Thanks Ron, I'll give it a whirl.
0
Pete
11/14/2009 10:50:45 AM
Hi Pete try to  copy (Cell) start Time of 2nd product & past link to the cell 
1st product  It looks simple . whenever you will enter the start time of your 
product this start time will be the end time of your previous product.

Khusro

"Pete" wrote:

> On Nov 13, 2:03 pm, Ron Rosenfeld <ronrosenf...@nospam.org> wrote:
> > On Fri, 13 Nov 2009 06:41:42 -0500, Ron Rosenfeld <ronrosenf...@nospam.org>
> > wrote:
> >
> >
> >
> >
> >
> > >On Fri, 13 Nov 2009 02:07:50 -0800 (PST), Pete <fell-wal...@hotmail.co.uk>
> > >wrote:
> >
> > >>I have a table of data for my Scheduled cutting list that is exported
> > >>from another program into an Excel Spreadsheet and from this table I
> > >>would like to be able to find the start and end time of the production
> > >>runs automatically in a separate table.
> >
> > >>The table is set up like this
> >
> > >>Planned order   Time               Product Description     Volume
> > >>12345              08:00:00          Product 1
> > >>3500
> > >>23435              11:32:00          Product 2                   5680
> > >>14567              13:24:00          Product 3                   10000
> >
> > >>and so on.
> >
> > >>I can find the start time by using Vlookup( Planned order,Datatable,
> > >>2,false) which returns 08:00:00. The end time of Product 1 is the
> > >>start time of the next planned order for Product 2 etc etc
> >
> > >>What I would like is a table that looks like this:
> >
> > >>Planned order     Start time     End time       Volume
> > >>12345                08:00:00      11:32:00           3500
> > >>23435                11:32:00      13:24:00           5680
> > >>14567                13:24:00      22:00:00           10000
> >
> > >>I hope I've explained this ok
> >
> > >>Regards
> >
> > >>Pete
> >
> > >The "best" formulas depend on whether you are working with Excel 2007+ or
> > >earlier versions.  2007+ has the IFERROR function, and earlier versions do not.
> >
> > >I used NAME'd ranges for the variables.  You can either NAME the ranges, or use
> > >cell references.
> >
> > >I don't know how you determine the End Time of the last entry; so in your
> > >example, the formula will return a #NUM! error.  This can be altered depending
> > >on your specifics.
> >
> > >There is error checking so as to return blanks for entries that are not
> > >present.
> >
> > >Here are the formulas:
> >
> > >Planned Order:
> > >    Excel 2007+:
> > >      =IFERROR(INDEX(Planned_order,MATCH(Start_Time,Time,0)),"")
> >
> > >    Excel 2003 and earlier:
> > >=IF(ISNA(INDEX(Planned_order,MATCH(Start_Time,Time,0))),
> > >"",INDEX(Planned_order,MATCH(Start_Time,Time,0)))
> >
> > >Start Time:
> > >=IF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:1)))
> >
> > >End Time:
> > >=IF(COUNT(Time)<ROWS($1:1),"",SMALL(Time,ROWS($1:2)))
> >
> > >Product Description:
> > >    Excel 2007+
> > >=IFERROR(INDEX(Product_Description,MATCH(Start_Time,Time,0)),"")
> >
> > >    Excel 2003 and earlier:
> > >=IF(ISNA(INDEX(Product_Description,MATCH(Start_Time,Time,0))),
> > >"",INDEX(Product_Description,MATCH(Start_Time,Time,0)))
> >
> > >Volume:
> > >    Excel 2007+:
> > >=IFERROR(IF(INDEX(Volume,MATCH(Start_Time,Time,0))=0,
> > >"",INDEX(Volume,MATCH(Start_Time,Time,0))),"")
> >
> > >    Excel 2003 and earlier
> > >=IF(Start_Time="","",IF(INDEX(Volume,MATCH(Start_Time,Time,0))=0,
> > >"",INDEX(Volume,MATCH(Start_Time,Time,0))))
> > >--ron
> >
> > I forgot to write that you enter the above formulas in columns in the first
> > row; then select them all and copy/drag (fill) down as far as required (or
> > until you start seeing blanks in the Start_time column).
> >
> > Also, you will need to format the Start Time and End Time columns as Time..
> > --ron- Hide quoted text -
> >
> > - Show quoted text -
> 
> Thanks Ron, I'll give it a whirl.
> .
> 
0
Utf
11/17/2009 2:04:01 PM
Reply:

Similar Artilces:

How to enable auto reply several times and change GMT time to loca
Dear all, I have two questions. 1. As default the senders only could get one autoreply even if he sent many emails, how to change the settings so that the senders could receive the autoreply when he sends email? 2. In SMTP logs the default time stamp is GMT, now I want to change it to local time zone, how could I do? Any suggestions would be appreciated! With best regards. Jobs -- Jobsz 1. You are probably talking about Out of Office replies. It is by design that it only send once per sender. This is to avoid mail loops and the like. Believe me, this is a good thing! 2. IIS l...

Starting up on start-up help!
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello all, <br><br>I'm new here so Hello. I just have a question to see if anyone can help here. I just recently bought a new MacBook Pro, and I got the Microsoft Office for it too. Well, I recently noticed that on start up, entourages My Day keeps opening up. Well when I right click the menu, I check off the box where it says to start on login. <br><br>Well here is the problem. Everytime I uncheck it, it still keeps opening up on start up. <br><br>Anyone know why?...

Excel and Word Attachments Time Out in OWA
I am having an odd problem in OWA. Many end users are experiencing time out problems when trying to access Word or Excel attachments in OWA on Exchange 2003. It appears to be only Word or Excel as others work fine. OWA is being accessed on a front-end server. However, all attachments work fine when accessed through the back-end server. Any ideas? ...

Need advice to start off a project
Hello! I have never really used Excel much but I have had an idea which could make some of the work I do a lot easier. I know Excel is powerful but I don't know the best way to approach it so can anyone out there help me? I make visits to places and record what kind of visit it was on a spreadsheet with the values in each cell being the date. At the bottom there is a summary box which shows, on each date, how many visits I made of each type. At the moment this is done manually but I am sure it can be done automatically only how? On a different sheet I would then like to have a summary of...

Cannot start Outlook 2002
My computer is usualy connected to an MS Exchange server at work. However I'd like to use Outlook at home with another e-mail account. When I try to start Outlook I get an error message : Cannot connect to exchange server. So I click work offline. Then, get another error message: Cannot start Outlook. Could not open information store. The the program quits. Anyone know a work around? Thanks. Create a new profile for your home account. Then set Outlook to prompt for profile. Select your home profile and Outlook will not try to connect to Exchange. --� Milly Staples [MVP - Outlook...

Exchange Services Do not Start After a Restart #2
I have a SBS 2003 Running and for some reason some of my Exchange Service do not start after a restart. System Attendand tries to start shuts down unexpectedly. I can go to services right after logging in and start the services and they start with no problem. Right before the error that service did not start, I get this warning: "A service process other than the one launched by the Service Control Manager connected when starting the Microsoft Exchange System Attendant service. The Service Control Manager launched process 2448 and process 3688 connected instead. Note that if this se...

Block two or more appointments at the same time in Calendar
Hi all, Do you know if there is any configutation in the Calendar or in the Exchange Server that I can do, to block users to create more than one appointment in the same time of another one in the Calendar? Thanks a lot. ...

What is the scope of ENTRYID UNIQUENESS in time?
Hello. Is it possible that outlook create an EntryId similar to an EntryId which was previously deleted (a week ago for example) 10x. No, it will not create the same entry id. I am no sure what you mean by "similar". Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "Julia" <NoOne@Home.com> wrote in message news:ugPgQBy7DHA.1636@TK2MSFTNGP12.phx.gbl... > Hello. > Is it possible that outlook create an EntryId similar to an EntryId which > was previously deleted > (a week ago for example) > > 1...

Macro or Lookup? Not sure where to start.
I have created two worksheets: 1) Auction Items Item# Table# Location# ItemDescription WinBid are the headers of the data. 2) Bidders Bidder# FirstName LastName I would like to be able to create a macro or something that will allow me to enter the item#, bidder# and winning bid price and have a sheet filled with. ie. Item# 2 (Handcrafted Table) Bidder# 12 (John Doe) Winning Bid $250 Can excel pull from two sheets and created another sheet with all the final details? I am a little new to excel (version 2000) it is the only tool/application available to us at this time. If anyone can poi...

AP trial balance doesn't match report for year end
Our auditors are here...yeah.... Is there a report or smartlist that can be run that will show what Accounts Payable Invoices were POSTED as of 12/31/06 but were entered after the year-end? They have the Trial Balance for the end of the year, but the report doesn't match because of invoices received for December that were entered after month-end for December. Also, any ideas on how to avoid this problem in the future? Somone reccomended doing a spreadsheet and tracking all invoices received after 12/31 -- Bridget Thiele ZefTek Inc Bridget: As long as the Posting Date on the doc...

Outlook starting problem
"Cannot start Microsoft Outlook. A dialog box is open. Close it and try again." ...

Running CHKDSK at start up
Is there a way to run chkdsk f/r on all five drives on one PC at start up? PC runs Windows XP Pro SP3. This way all drives would be checked and errors fixed, if necessary, in one go, at start up on this machine. We intend to do this on this heavily used PC from time to time - we do not need the desired chkdsk functionality to kick in at every boot! Regards and TIA. Avatar -------- "Avatar" <Avatar@re.birth> wrote in message news:hrb4n2$53i$1@news.eternal-september.org... > Is there a way to run chkdsk f/r on all five drives on one PC at start up? ...

time listing
I have a form that has 2 fields on it for time start and time end (not date). A third field records the difference between the start and end time. If a person records a time of 8:30am to 9:30am the third field shows .99 as the difference. I need it to show 1 for one hour of time. The times will never crossover midnight (if it did I think someone needs to get a life). The times are typed in as military time but show on the main form as regular time format. The code line that fills the 3 field with the difference is as follows: Me.txtWorkTimeAmount = 24 * (Me.txtProjectWorkEndTime ...

Excel 2003 - VBA
Hi. This is a curiosity question. What is the advantage of using the With/EndWith statement. I see it in many of the examples, but it seems to add lines of code and a level of complexity to in many cases, a simple problem. Example: With Sheets("Control") Testdata = .Range("D4") End With Seems overly complex when the following will do. Testdata = Sheets("Control").Range("D4") In fear of miss-out on something really cool, I am awaiting the words of wisdom. Thanks, Craig Advantageous and saves time in looking at the sheet a/o...

Starting a new paragraph within a cell
How do you create a line break within a cell? For example, if wanting to list 2 or more items it looks better if each one is printed under the other as a list. Or in a comment column when needing to start a new paragraph, again within the cell. Hi. You can press Alt + Enter to create a line break within a cell. Kath firman wrote: > How do you create a line break within a cell? For example, if wanting to list > 2 or more items it looks better if each one is printed under the other as a > list. Or in a comment column when needing to start a new paragraph, again > within th...

How do I add consecutive numbers but start over at a break in the.
add consecutive numbers but start over at a break in them. I'm trying to calculate consecutive days of attendance. ...

Can't Start Any Program
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel It has been two weeks since I can open an Office Program. Please HEEELP! This is my word error report: Microsoft Error Reporting log version: 2.0 Error Signature: Exception: EXC_BAD_ACCESS Date/Time: 2009-09-09 19:04:02 -0400 Application Name: Microsoft Word Application Bundle ID: com.microsoft.Word Application Signature: MSWD Application Version: 12.2.0.090605 Crashed Module Name: CoreFoundation Crashed Module Version: unknown Crashed Module Offset: 0x00075354 Blame Module Name: CoreFoundation Blame Module Version: unk...

CD does not start
After installing XP on a new disk everything appeared normal. I was able to install a few applications from their cds. Then I attempted to install an application from a downloaded file, but it did not work. So I installed MS frame works and windows installer. Then I was able to install the application from the downloaded file. When I attempted to install another application from its cd (with autorun), nothing happened, namely it fail to start. If I force the setup.exe from Explorer, the error message shows up: "the application configuration is incorrect". Thinking for...

Length of time between 2 database entries
Helpdesk calls are logged in 2 tables, 'Calls' with 1 row per call, and 'CallActions' with a variable number of entries per call log. The schema for CallActions is: CallID, ActionID, datestamp, narrative The Narrative can be made up of free-form text or just contain specific text to show something has happened to the call, e.g. '**new', '**open', '**investigating' etc. The CallID is unique in the 'Calls' table, the ActionID is unique in the 'CallActions' table. I need to pick out both '**New' and the first '**Open...

Money 2007 tries to update on each start
On each start up, Money 2007 advises that in order to run properly an update to Money 2007 is necessary. When I click OK it downloads files and again I click to start the upgrade. After a few minutes the update completes and a dialog box advises that I should restart Money and if it will not open properly I should restart my computer. I do so and all seems to be OK, but on starting money the update dialog box is back. I checked the Money folder and the update log shows that the update completed. So how do I stop the annoying update dialog box from displaying on each start? "GWL&qu...

What is the main thing to remember to get started in EXCEL?
What are some tips to make Excel easier to understand and employ? Just remember that Excel is not a database, though it can do some database functions, and it is not a word processor, though it can do some word processing functions. Get a good book - one by John Walkenbach would be a good choice: http://www.j-walk.com/ss/books/index.htm HTH, Bernie MS Excel MVP "Mr.Harrison" <Mr.Harrison@discussions.microsoft.com> wrote in message news:3796CE4E-1D28-4BDD-9D8F-E378C10F892F@microsoft.com... > What are some tips to make Excel easier to understand and employ? if you spen...

Long processing times
I have a HP Vectra VI (Pentium-4) PC with 256-K RAM running Windows 2000 and Microsoft Office 2000 Professional. When I'm working on a large Excel 2000 worksheet, the run-time to complete an action (like calculating; replacing; inserting rows or columns; etc) gets progressively longer the more times I do the action. For example, the FIRST time, it completes almost immediately; the next time, it many seconds; the next time, a few minutes; the next time, several minutes; then many minutes; and, in some instances, an hour or more. (The longest time has been over 3 hours). It seems that Ex...

Outlook 2007 won't start, message, can't start microsoft office o.
I run Windows 7 and Outlook 2007 just quit working. The error message is: Cannot start Microsoft Office Outlook. Cannot open the Outlook window. I have had a similar problem because I keep my pst file on a network share so I can use it with my roaming profile, and sometimes the network share goes awol.... To reset the outlook window run 'outlook.exe /resetnavpane' at the command prompt. "Tony Wybrow" wrote: > I run Windows 7 and Outlook 2007 just quit working. The error message is: > Cannot start Microsoft Office Outlook. Cannot open the Outlook w...

End loop macro with count
Help! I want to limit the number of times my loop macro iterates to, for example, 20 times. I have attempted to use a "count" function but I don't have a working example, I can't locate one, and my attempt doesn't work. Can someone please provide a simple way of doing this. The routine has apprximately 15 sub routines. A count limit that applies to a specific sub routine will be perfect or one that applies to the whole routine will be near enough to. Thanks in advance. Jason, Try using a For loop. E.g., Dim N As Long For N = 1 To 20 ' your code here Next N ...

EXCEL VBA
run-time error 1004 - Copy method of sheets class failed. Sheets("All_Reg_Data").Select Dim i_WHY_AM_I_5 As Integer i_WHY_AM_I_5 = 5 Range(Cells(1, i_WHY_AM_I_5), Cells(1, i_TotalNumberOfColumns - 1)).Select Selection.Copy Sheets("Reg_Data").Select Cells(1, i_WHY_AM_I_5).Select ActiveSheet.Paste Sheets(Array("Reg_Data", "Reg")).Select Sheets("Reg").Activate Sheets(Array("Reg_Data", "Reg")).Copy I received the error on the final line. The table consists of 6 sheets. The Reg_data is a table of Data, the Reg is a graph. No...