charting date and time data (every minute type)
i have a minute by minute data of certain measurements, which i
wouldlike to go on my x-axis with the y-axis being the measurement
this data goes on for a series of days, with certain breaks of few
minutes in them (mostly due to instrument maintenance)
when i do chart this data, excel ignores the gap in data and thus i get
a erronous display.
also the x-axis doesnt show the date or th time, just 0:00:00
help would be appreciated
Message posted from http://www.ExcelForum.com/
Use a XY Scatter chart and you will get the desired effect. If you
still don't, ...Subtracting lunch breaks from different shift times
I am trying to calculate the time spent by operators on the shop floor
actually working on a product. I have the start times and end times but
these times also include lunch breaks. Is there anyway in Excel I can
actually subtract the time of the lunch break.
For example if the operator works from 11:30 am to 1:30 pm I would like
to subtract 30 min from it (12:00-12:30). If the operator works from
11:00 to 12:15 and then 12:30 to 2:00 pm I would like to subtract 15
min from it (12:00-12:15) and add the remaining time (12:30 -2:00). I
have 1000 rows and doing this manually would take a lot of..."This bill will end at some time"...
Please can you confirm the behaviour : Once "This bill will end at some
time" is completed, after the "Date of Transaction", the Bill will
automatically be deleted from the Bill Summary.
Is there anyway to use this option, but not have the Bill deleted? The
reason is that the payments may end after 10 payments but then break for 2
months, then resume for another 10 payment at a higher payment. Also, in
another instance, insurance payments maybe set for 12 payments for the 1st
year, in this case, I would "End the bill" on the 12 payment, then wait for
no...Date and Time Table Modified
I have 4 forms used by managers to enter data. When they enter data, the data
is saved in tables. I would like to include a date and time stamp so that I
know when they entered each piece of new data. Do I need to have a field in
my table to collect the date and time? How do I collect that in my form?
Yes, you need to add a field to your table.
In the form's BeforeUpdate event, put code to update that field. Assuming
that you named the field LastUpdated and that you included the field in the
form's RecordSource, the code would look something like:
Private Sub Form_Bef...time stamp upon closed
I am trying to have a time stamp mark my date_completed field when an
operator changes the status field to closed. Closed is in my tblstatus table
along with submitted, pending, postponed, ect. I am guessing that the code
would be in the afterupdate event of the status field on my form but not
sure? Iwould rather the system date the field rather than an operator. Any
I would suggest that you use a combo box for the status field. That way, the
correct codes will always be entered.
Then to update the date_completed field in your table, put a text box on
y...malibox size warning message multiple times
the "Your mailbox has exceeded one or more size limits set
by your administrator" message is being sent to users once
an hour instead of once a day. where is the setting to
Depending on the version of Exhange:
5.5 - Properties of the Private Information Store container. Limits tab.
2000/2003 - Properties of the Maibox Store that owns the mailbox in
question. Limits tab.
Hope that helps...MMS
Malvin M. Seale, MCSE, MCSA
Microsoft Product Support Services (Exchange)
* Please do not send email directly to this alias....Time sheet issues
There are three questions
I am preparing a time shhet.
To strart with I have to prepare a blank sheet and give one sheet for each
Here are the blank walls I am hitting
1. I want to format a cell (E2 in my time sheet) in such a way that if
enter "1" it should display "January" and so on. How to do it?
2. The First cell of last row (A 34 in my of the time sheet) should have 28,
29, 30 or 31 depending the conditions of E2 and H2 which has month and year
3. The cells B4 to B34 should have days cooresponding to dates (number) in
A4 to B34
They sho...Process server and times events
There seems to be mention of process server supporting timed events but I'm
unable to find any more detail on this function - can anybody help? Is this
for report server, or is that a separate function altogether?
I like to always know when a particular entry was made. So if I have a
new contact, I can have some automatic process whereby when I hit
"SAVE" it will put a date somewhere .
Along those lines -- keeping the information regarding when I sent and
when they sent a message last is important. but it isn't included in
the DB or .vcf - I have to reload my 2200 contacts from time-to-time
and when I do, that data is lost. Is there another way to ensure that
I can keep this data?
Using Office 2008
...Microsoft Money 2001 Won't Install 2nd Time Around
Will you help me, please? I had installed MSN Money with no problem. But then
I uninstall the software because I load it under a wrong user account. After
logging back in under the preferred user, I attemp to reinstall MSN Money the
2nd time around but this time it would not install. It will not do anything.
I guess it was a misstake in uninstalling it the first time around. Can
anyone tell me what is it I need to do to get the computer to install the
On Sat, 5 Jun 2010 00:45:10 -0700, Otis
>Will you help me, please? ...I fixed the date and time and the time zone. Now reply me please
I have some questions in outlook 2003, can anyone help me?
1-how can i in the appointment type a subject with special format (red,
2-whent a task is 100% completed, how can be deleted automatically.
3- I need to filter only the available time on a specific day.
ex if i have 2 appointments today on a specific time, what i need to see
the available time for other new appointments.
4-If I have a lot of appointments on a specific date that are colored with
labels and have a specific show time as (busy,tentative), when i go to print
this calendar with the "calendar detai...Has exchange taken most of the resources?? Is it time to upgrade????
I have an SBS2000 server running SQL2000 and Exchange 2000. For the last 2
weeks after the exchange implementation my server has becomes short on
memory. I came back today from a 2 week vacation and got this surprise with
a message on the health monitor a warning from Paging file.The % Memory
Available is 11MB from 1GB that's too low, why is this happening and what
can I do to solve this?? My C drive space is 4.2gb with 38% of free disk
space and my E (share Drives) drive is 32 gb. with 56% of disk space. When I
go to the System properties in the performance options this is ...Workflow Call Assembly to add Date or Time
I cannot get a very simple workflow to work. All I want it to do is
update a datetime field to add one month! Workflow monitor says it
completed, but it has never worked... Has anyone ever been able to
make this work?
On 26 Mar, 18:54, "DubSport" <jamie.carmich...@cmgl.ca> wrote:
> I cannot get a very simple workflow to work. All I want it to do is
> update a datetime field to add one month! Workflow monitor says it
> completed, but it has never worked... Has anyone ever been able to
> make this work?
Show your workflow rule
OK here it is. its a manual rule, s...Calculating percent of times a value is in a column and total #
Ok so I have a column with values in it. Say A4:A12, the values entered will
always be 1, 2, 3, or 4. I need a formula that will calculate the % that say
a 1 appears in that range and I need a formula that will calculate the total
number of 1s in that range.
Format as percent
"clbritt76" <firstname.lastname@example.org> wrote in message
> Ok so I have a column with values in it. Say A4:A12, the values entered
> alwa...i want my messages say "you replied" all the time?
When I reply to an email, it says "you replied on 7:26am" but that status
message leaves. How can I make it stay all the time, and make the little mail
icon turn into a mail with a "backwards arrow" showing me I replied or
forwarded a message? I can't keep going back to my sent box. Please give me
clear concise directions. Outlook Help has been no help.
Outlook version? What kind of e-mail account is this -- POP3? IMAP?
Exchange? Does the message in the Infobar disappear from both the reading
pane and the opened message?
MVP - Outlook
**...Date and Time ??
I had a question working about date and time it had 11 or 12 posts and now
Any Idea what happened to it?
Sorry I found it.
> I had a question working about date and time it had 11 or 12 posts and now
> it's gone.
> Any Idea what happened to it?
"Duane" <Duane@discussions.microsoft.com> wrote in message
>I had a question working about date and time it had 11 or 12 posts and
> it's gone.
> Any Idea what happen...Working time and days
I would like to be able to caculate working time when the cell format is
4/1/2005 6:40:26 AM (not seperated into date and time)
Cell A1 dd/mm/yyyy h:mm:ss (First Day)
Cell A2 dd/mm/yyyy h:mm:ss (Last day)
Working hours would be 8:00 to 17:00
Public holidays need to be taken out too
The result should be working days hours and minutes or just hours and
minutes, so that Saturday, Sunday, public holidays & between the hours of
17:00 to 8:00 to the next working day would not count.
I've tried using:
But I think this ...Case Resolution & Total Time in CRM3.0
I have noticed that the Total Time displayed when Resolving a Case is not
accurate in that it only seems to show time spent on email activities. I
have one case where an 8hr appointment shows up in the History but this is
not being included in Total Time. Any ideas ?
...Excel opening a "phantom" worksheet at random times
I have a user who will have a phantom Excel spreadsheet, entitled Object,
open at random times while she is trying to open another spreadsheet.
This Ojbect spreadsheet will stay open, and she can open other spreadsheets,
but the only thing that will open is the Menu bar, toolbars, and the status
bar. The file itself doesn't open, the space is empty and the user can see
When this happens, the user has to shut down her machine, not a restart,
before she can continue on in Excel.
...Converting time to decimal then rounding
I have a formula
Where T11 is 22:43 and R11 is 22:34
The difference of these time values is 9 minutes or .15. Currently I am
getting the result of .1 because it is not rounding up. The result I need is
..2 -- so that Excel will round .01 to .04 down and .05 to .09 up.
How should I adjust my formula? Thanks!!
"JB Bates" wrote:
> I have a formula
> Where T11 is 22:43 and R11 is 22:34
> The difference of these time values i...Average lead time calculation #2
Scenario - we have an item on a PO with an average 30 day lead time and
three receipts against PO. The first receipt is 15 days early, the
second receipt is on time, and the third receipt is 15 days late (all
based on promise date and actual receipt date). In this scenario, does
GP average all the receipts for a an average lead time of 30 days or
does it weight late receipts heavier than early ones?
NOVA Solutions LLC
...Another Time Conversion question
The new report we get our time information is in the following format:
10:45:32 (hh:mm:ss). I am at a lost in how to write a formula that will
convert that figure to seconds.
Any help will be very much appreciated.
It is a fraction of 1 day, so multiply by 24 to get hours, by another 60 for
minutes, and another 60 for seconds
(remove nothere from the email address if mailing direct)
"Sean Skallerud" <SeanSkallerud@discussions.microsoft.com> wrote in message
> The new report we g...Cashier Time Clock Report error ( -2147467259 )Conversion failed
Cashier Time Clock Report error ( -2147467259 )Conversion failed when
converting datetime from character string.
I am using RMS 2.0.
I am trying to run the Cashier Time clock report for last two week pay
periods 2/14/2008 to 2/17/2008.
I read post from that you change couple of numbers in Active reports and you
could fix a problem, but I was unable to find that post.
...Attachments saving time
When I receive a mail inculde attachment and save it to my PC. The time of
the saved attachment is alway GMT + our PC Time Zone. For example: My PC
setted time zone is GMT +8 Location is HK. When I save the attachment at the
time 13:00 and check it on my explorer, the listed file saved time is 21:00
at the same day. How can I fix the problem? Thanks
I'm using Outlook 2000 SP3
...OUTLOOK 97 Resetting time span for email arrival
I am trying to avoid going into TOOLS "check for new mail"
and have OUTLOOK continuously display new emails. What can
I do? I did not see anything under "Options" that gives me
a choice for resetting.