Compare Sheets #2
I'm going insane
I'm trying to compare two sheets using Walkenbach's approach but for
some reason when I use it...certain values don't show differences.
Sheet 1 (Range Name is Grid) has 18000 on Cell A1
Sheet 2 (Range Name is OldGrid) has 18000 on Cell A2
So if I change Cell A1 on Sheet 1 to 1 it should show me change but
no...it just does nothing. However if I type 133...it shows change.
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
Selection.FormatConditions(1).Interior.ColorIndex = 40
Help really appreciate...How can i use a command button to validate date and time
I have two command buttons, each on a different sheet. i need both of them to
put the current date in one cell on its sheet and current time in another on
its sheet. i also need these cells to be locked so the user can only edit
these cells by clicking the command button. Any answers?
...Importing Item List for the first time
We are currently change over from Quickbooks Accounting 2002 Pro to MS Retail
Management System and need to know the easist way to import item list into MS
Easiest is to upgrade to QB 2003 or higher. Then follow these instructions;
Otherwise, does 2002 give you the ability to export a report to Excel? If
so, create a report of your inventory items, export to an Excel file and
then use the unsupported RMS Import Utility, again in CustomerSource.
I think you are going to _have_ to upda...Make outlook run as if its the first time
How do I make outlook run as if it is the first time?
I messed with the settings... pleaseeeeeeee help!
>How do I make outlook run as if it is the first time?
>I messed with the settings... pleaseeeeeeee help!
Uninstall it and reinstall it. What settings did you change that no longer
meet your requirements? Why not simply change them back?
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerospace.com is the domain.
I don't speak for Smiths, and Smiths doesn't speak for me.
"Br...Converting Numbers to Time (A second probelm)
Due to several peoples help in this group I learned some very helpful
date/time functions but here is one that has since eluded me...
What I am trying to do it convert...
1/6/1900 22:40:25 to the total number of hours and seconds.
As if the start date was 1/1/1900 00:00:00.
Or in other words I have a
start date of
End date of
Total time of
How do i convert the 1/1/1900 2:12:07 into 26:12:07
Thanks for all your help,
Just format the answer cell as [hh]:mm:ss
"Smonczka" <...Pulling Kronos Activity Time Into Great Plains
Does anyone one know how to import labor hours into Great Plains 8.0? We use
Kronos Workforce Activities to track our labor time.
Use Integration Manager or eConnect.
Charles Allen, MVP
"Chad A" wrote:
> Does anyone one know how to import labor hours into Great Plains 8.0? We use
> Kronos Workforce Activities to track our labor time.
...Help! Search & Replacing time formats
I have a whole spreadsheet full of fields similiar to the following
10:00AM 12:15PM 2:25PM 4:40PM 7:00PM 9:20PM 10:00PM
12:20PM 2:25PM 4:30PM 7:15PM
10:00AM 12:30PM 2:45PM 9:15PM
10:40AM 1:10PM 5:00PM 7:20PM 9:35PM
I need to convert all times to 24 hour, and drop the AM & PM.
The later is easy, but how do I do a quick Search & Replace without
incorrectly converting 10:**AM to 22:** etc.
Any tips would be appreciated.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly fro...Time Card setups
We are implementing HR for a client. What is the best practice in importing
Time Code assignments to employees and establishing beginning leave balances?
...Add time to a date time group
Hi, thanks for any help in advance
I have my date and time displayed in this format dd hhmm "K" mmm yy
which shows up as 03 1800 K Sep 08.
I would like a formula that will add 30 min to this time group so it becomes
03 1830 K Sep 08
Assume your date/time is in A1, then you can do this in another cell:
Format the cell in the same way as A1 (using the Format Painter icon).
Times are stored in Excel as fractions of a 24-hour day, hence the
divisions by 24 and 60.
Hope this helps.
On Sep 4, 12:28=A0am, Patrick <Patr...@discussions.microsoft.com> wr...Cube View required to count Milestones over time
I have a basic Data Analysis view which counts milestones over time..however
I now what to count a breakdown of those milestones over time..I have
Milestone types 1,2 and 3. I have created a Milestone Type custom field at
task level to set a value against each milestone ie 1, 2 or 3. How do I
then get this Milestone Type field into the Cubes in order to add it to the
view? Which cube should I be using etc??
...Average interpurchase times
Table is organized like this:
Date Purchase Quantity
How do I calculate the average time between purchase?
Thank you for any help you can provide.
SELECT Avg([Date]-DMin("[Date]","Yallop")) AS AvgDaysBetweenPurchases
BTW: Date is a very bad name for a field or table. It's a reserved word and
can cause problems if you forget to put the [ ] around it. Read more about
reserved words at:
http://supp...Run Time Error 3711
I get this run error occsionally on a machine with Store Operations Manager
running XP Pro. Run Time Error 3711
I would appreciate any help.
...use a time value in a bar graph
i have values in a series
I would like to use e5 in a bar graph it gives values which would make sense
only to excel
If the axis is formatted as time, it shouldn't be a problem. If it doesn't
choose the scales to give clean divisions, you can choose an appropriate
unit on the axis, such as 03:00.
"pdfrone" <firstname.lastname@example.org> wrote in message
>i have values in a series
> c5 9:01
> d5 21:01
> e5 =(d5-c5...Outlook Multiple Profiles at the Same Time
I have two separate icons set up on my desktop to call
Outlook using /profiles switch for profiles A & B. I can
double click one for A, and it opens my POP3 account for
profile A. Then I close it and double click one for B,
then it opens my Exchange Server account for profile B.
The problem is if I don't close the one for profile A and
try to open the one for B, then even if the switch is set
to open profile B, it just opens profile A again. Can
someone tell me how I can have two separate Outlook for
two separate profiles open at the same time?
Adding POP3 to my Exchange S...Suming Up Time over the course of days
I have a sheet the contains event durations on specific days. Some
days have more than one event. I would like to add up all the event
times for each day on a second sheet and (line) chart the results
The list get longer with each event.
Tuesday Nov.2 2010 10:16 am 00:37:22
Tuesday Nov.2 2010 08:28 am 00:15:48
Monday Nov.1 2010 08:30 am 01:03:07
Sunday Oct.31 2010 06:36 pm 00:09:20
Sunday Oct.31 2010 06:17 pm 00:03:26
Sunday Oct.31 2010 05:27 pm 00:07:42
Sunday Oct.31 2010 11:15 am 00:27:19
Sunday Oct.31 2010 08:56 am 00:45:26
Saturday Oct.30 2010 12:44 pm ...Solved! (This time for sure!
Wait... Bullwinkle? Boris? Hmmm....
Boris, I owe you. I never in a million years would have guessed it was the
icon, but that's exactly what it was. I just got an e-mail from the client.
The system now works 100%.
If by chance you are on facebook, please add me as a friend, or just send me
an e-mail sometime - email@example.com
And say "Hi!" to Natasha for me!
I don't know Bullwinkle, and Boris is not my real name, but I'm glad it
On Sat, 17 Apr 2010 14:06:40 +0200, Boris Pauljev
<firstname.lastname@example.org> wrote...One link breaks every time I open a workbook...
I have 3 workbooks tied together with links. One is a source only, the other
two push and pull data.
One of the sources, Payroll Master, on opening updates all links fine to the
source only workbook but not
to the third workbook (which is in the parent directory). Every time I open
it it prompts me to show it where the Payroll Entry is. Doesn't matter if I
hit cancel and
do Edit Links, I can change it there, but will still lose it upon closing
(the link appears in the box and looks ok, just won't update...)
Try going Edit->Links. Break the link and re-establish it? That m...Max. no. of characters in a message box line is less in Vista when compared with XP
I have noticed in Vista, the maximum no. of characters which could be
displayed in a messagebox line is 85 characters where in XP it was 131
Following is a summary when compared this with OSes,
OS - Max. no. of characters per messagebox line.
XP - 131
Vista, Windows 7 - 85
Windows2008 Server x32 and x64 - 81
Following is a code in VB to run in Vista simulate the problem which spans
into 3 lines, where it was expected in 2 lines.
MsgBox ("**Maximum number of characters per messagebox line in Windows Vista
is 85 characters.**"+CHR(13)+CHR(10)+"...limit time for outgoing emails
I`m running exchange 5.5 sp4.
I wanted to know if it possible to control the time that mail can stay in
the outbound of the mail internet connection or the number of time that
exchange retry to send them?
If it possible, what is recomended?
Thank for the help,
I cant remember the exact location, but you can adjust those values on
the IMS. Poke around, you'll find it.
On Thu, 3 Jun 2004 19:47:44 -0400, "Tom" <email@example.com> wrote:
>I`m running exchange 5.5 sp4.
>I wanted to know if it possible to control the time that mail can stay i...VB "run time error"
I was just wondering if anyone knows of a fix for a VB "run time error". I
try and access a table and it's givng me an error message saying run time
Any help would be great.
"Busty" <firstname.lastname@example.org> wrote:
>I was just wondering if anyone knows of a fix for a VB "run time error". I
>try and access a table and it's givng me an error message saying run time
What is the exact error message?
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can ...Tracking Time
i want to build a time tracking function in order to track each occasion a
record in Table A is being updated. Table B stores the Time, Now(), Name,
fOSUserName() and a field related to the Key field of table A.
When a record in the form related to table A is updated (on the Before
update event) i want this to be recorded in Table B...
Do i need a separate form (not visible) to capture this data or can i code
Form A, on the Before Update event or on the Close event, to update the
related record in Table B?
What you are trying to do ...How do I sample hourly data one time per day
I have hourly data from an instrument and would like to reduce the data set
(see example below) to one point per day, either by selecting a specific time
(e.g., 00:00) each day, or by averaging all of the values for one day. The
data files may contain more than one month's worth of data per file (i.e.,
quite large files).
8/11/2006 00:00 17.06
8/11/2006 01:00 17.05
8/11/2006 02:00 17.05
8/11/2006 03:00 17.05
8/11/2006 04:00 17.05
8/11/2006 05:00 17.05
8/11/2006 06:00 17.06
8/11/2006 07:00 17.06
8/11/2006 08:00 17.05
8/11/2006 09:00 17.06
8/11/2006 10:00 17.06
8/11/2006 11:00 17.06
8...Daylight saving time Strange behaviour
I have created an application where I am using
CTime( int nYear,int nMonth,int nDay,int nHour,int nMin,int nSec,int
nDST = -1);
Constructor to change the dates to UTC before saving them to
I have set my timezone to Easterntime(US&Canada) which is 5 hrs behind
I entered the following date, 01\11\2006 12:00:00PM.When its converted
to UTC,the date its showing is 01\11\2006 4:00:00PM.
In 2006,DST ended on 29\10\2006,thus ideally it should show
This behaviour is shown for dates ranging from 30\10\2006 to
Analysing the issue,I checked my...Subtracting military times (decimal format)
I apologize if this has been asked & answered many times before, bu
after reading for days in this forum, I can not find a direct answer t
I have timecards that are already displayed in military/decimal format
I do not want to convert to hours/minutes and I'm not interested i
displaying results in hh:mm format. I do not want the date displayed.
simply want to calculate each employees total time worked for thei
shift's "start" to "end" (keeping the decimal format). Results are no
rounded...employees are paid for all fractional hours. There are no se...Count the number of times a character appears in a field
This is a multi-part message in MIME format.
How can I count the number of times the @ symbols appears in a text
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content=3D"text/html; charset=3Dus-ascii" =