actual time and date
Does anyone know the command for adding the actual time and date to a
thx in advance
kizzie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26092
View this thread: http://www.excelforum.com/showthread.php?threadid=394484
How about ="String"&Text(Now(),"d/m/yyyy hh:mm")
"kizzie" <email@example.com> wrote
...X axis date
I'm using Excel '97 (Yeah, I know, but it's all I can afford at the moment)
I want the X axis to always display a month beyond the latest date, so
that the line graph stops short of the right hand side.
I can get the Y Axis of value to stay ahead of the game by a consistent
amount, but the date defaults back to the latest date when Auto for Max
value is ticked.
Is this possible? Will I have to use VBA?
Please clue me in.
Add a series to the chart. It can consist of a single point, where the date
is calculated as the maximum in your date column plus 30, an...Is it posible to have a date/text field in an access db
Can I have a date field that is also a text field? In some instances a date
is not required and it is important that it is specified as NA in that field.
=?Utf-8?B?QWxiZXJ0?= <Albert@discussions.microsoft.com> wrote in
> Can I have a date field that is also a text field? In some
> instances a date is not required and it is important that it is
> specified as NA in that field.
You can add a checkbox beside the date to store true or false
associated with N/A, and use that to hide the textbox on a form or
r...time and curency
if i wanted to put 2 times in and get excel to work out the time take
in hours between it and then times that by another cell which is th
hour rate in � giving a out put in � how would i do it?
i cant get excel to take the hours worked and convert it into mone
earned. for example 4:55 hours and �5 hourly rate would be �24.58 but
cant get excel to do this.
Attachment filename: wages.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62592
Message posted from http://www.ExcelForum.com
If the earlier ...Setup was unable to find instance of CRM services
This occours when I try to run the Sales for Outlook, CRM
works fine on the same machine through IE.
is your workstation and the crm server in the same domain?
"Vignir" <firstname.lastname@example.org> wrote in message
> This occours when I try to run the Sales for Outlook, CRM
> works fine on the same machine through IE.
...Calculating time between successful data transmissions
Hi - I need a little help devising something that will
basically do the following:
I have a set of dates of transmissions and I want to find
the time between successful transmits. See below:
11/11/04 6:01 DIAL 1-800-827-1159
11/11/04 6:02 Nothing was received.
11/11/04 6:04 DIAL 1-800-827-1159
11/11/04 6:07 DIAL 1-800-827-1159
11/11/04 6:10 DIAL 1-800-827-1159
11/11/04 6:14 DIAL 1-800-827-1159
11/11/04 6:17 DIAL 1-800-827-1159
11/11/04 6:18 Nothing was received.
11/11/04 6:20 DIAL 1-800-827-1159
11/11/04 6:24 DIAL 1-800-827-1159
11/11/04 6:25 Nothing was received.
11/11/04 6:27 DIAL 1-800...Project Time & Expense
We just upgraded to GP 9.0 and BP 3.0. My manager noticed that when she
returned a timesheet in Project Time & Expense, it no longer allows her to
supply a note. How do we get back that option?
I had to apply the setting for 'AutomaticProcessing" to 0, described in
Article ID# 921642. I noticed that besides "AutomaticProcessing" there are
other fields in table "PmaTimesheetConfig". One is called
"ApprovalNoteSubmit". Does this turn back on the approval rejection note?
Can someone list what behavior each of these fields changes?
The time recorded on all my incoming email is clearly and unequivocally
incorrect, by several hours. I haven't yet checked to see if my outgoing mail
is arriving at its assigned destination also with an incorrect time. My OS
(Vista) date/clock is showing the correct values. Can anyone explain why this
is happening and how I might resolve this issue?
I thought I was undecisive but now I''m not too sure
"Pompeygill" <Pompeygill@discussions.microsoft.com> wrote in message
> The time recorded on all ...create date from separate cells
I want G1 to read:
using a formula
Any help appreciated
The problem is your year in C1, Excel would probably think it is 1908. Can
there be no earlier years than 2000 you can use
then format the cell as
"Flash in the Pan" <email@example.com> wrote in message
&g...Convert Text to DATE #3
I hope you can help with a problem we have in the office. We've got over
4,500 observations which are supposed to be in Date Format. Instead they are
in text format, e.g. "01.06.2005 08:26" or just "09.03.2005" but we need to
perform various duration calculations on them, so we need them in the Date
I tried Format Cells-> Category = Date, but it doesn't work. It works
however when I enter the cell and then click "Enter". very strange
Please help if you have an idea how to do it...
Thank you very much
Try =DATEVALUE(SUBSTITU...Help finding first payment date and amount
I have a simple table and I need help finding the first payment date
and the amount payed.
Here is the table
CREATE TABLE [dbo].[Payments](
[MemberID] [nchar](10) NOT NULL,
[PaymentDate] [datetime] NOT NULL,
[Amount] [money] NULL,
CONSTRAINT [PK_Payments] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Here is some data to insert
insert into payments values (101,'01-01-2009',20)
insert into payment...How time work with a file excel ?
Hello from Italy ,
i have an old five of excel (five years old) .
I work with this every day , now i have the curiosity to know : how many
hours it was open ?
if I understood you correctly there is no chance to get this
> Hello from Italy ,
> i have an old five of excel (five years old) .
> I work with this every day , now i have the curiosity to know : how
> many hours it was open ?
This is possible with a VBA macro, but I have to write that.
Maybe google can serve you bett...Sent Mail Dates Replaced with word NONE
I am using Outlook 97 on a W2k machine.
I have suddenly developed a problem in the Sent Items folder. Several
weeks back the sent date changed from the usual date to the word NONE.
The other folders seem to be OK. What and where can I check settings to
look for the root cause of this?
Wishing you a VERY HAPPY NEW YEAR!!
May it far exceed your expectations.
...julian date #3
Is there a formula or line of code that, in a date cell, would automatically
convert a date entered in the 07/16/04 format into the 04188 julian format?
You can't have a formula in a cell and make an entry in it - the
formula is overwritten. You can use an event macro:
Put this in the worksheet code module (right-click the worksheet tab and
choose View Code):
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim nYear As Long
Dim nDays As Long
If .Count > 1 Then Exit Sub
If Not Intersect(.Cells, Ra...Remove time from date upon export to csv
I cannot remove the time from the date when exporting invoice data to a csv
I have followed previous advice and created a query based on my tblInvoices
table, in which I have formatted the InvDate field in the Design Grid as
Date: Format([tblInvoices.InvDate], "dd/mm/yyyy") (UK format)
In the Query, this is fine - just the date, no time shown.
I saved an export spec in the Advanced bit of the File/Export wizard.
But in the resulting csv, there are six zeroes representing the time!
However if I do a manual export by following exactly the same process bu...Entering Dates in Excel
Is it possible to just enter 020304 in a cell and have
the date come out correctly or must I put -'s or \'s to
seperate the numbers
without using VBA this is (AFAIK) not possible. Have a look at
for a VBA solution
> Is it possible to just enter 020304 in a cell and have
> the date come out correctly or must I put -'s or \'s to
> seperate the numbers
...Opening calendar (month view), I want today's date on top row
I open and use calendar in the month view. if todays date is in the last week
of the month, then it is in the bottom row. That means I see all of my
appointments, etc. from the last month rather than those in my future. I
would like the (uncompressed weekend) month view to open with today's date in
the top row... is that possible?
No, its not possible.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:firstname.lastname@example.org....How to change default date formula on Excel worksheet
Want to change the default formula for date on worksheet.
Currently any date input auto displays as "17-Apr" for example.
I know how to format to display 4/17/2010, but want this as default when I
open the worksheet.
In excel 2003 it was easy set up in "Options" in 2007, I can't seem to
figure how to set this default.
Change it Windows CP, Regional & Language Options.
"alexanderoux" <email@example.com> wrote in message
I ma using Outlook 2002 sp3 in a ADS Domain environment.
I used to use Outlook 2000. With 2000 I had the client
login configured so that the userid and Domain name were
pre populated when Outlook launched.
can someone tell me where in the Registry that is
specified for Outlook 2002?
Thanks in advance for any help provided!!
"WIlbur" <firstname.lastname@example.org> wrote in message
> Thanks in advance for any help provided!!
This is a complicated task that Outlook Profiler seems to have fixed.
...view date navigator
has anyone found a way to view the "date navigator" while
they are in their inbox?
Nope. Can't be done.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
"lisa" <email@example.com> wrote in message
> has anyone found a way to view the "date navigator" while
> they are in their...Display a range of dates in a calendar
How can I show a range of dates in a pop-up calendar ??
Let´s say I want to show the range between 2010-03-10 and 2010-04-02 with a
different color than the other dates in the calendar. How to do ???
Thanks in advance for Your help
Have a look at the Flex Grid Appointment-Bookings Demo at :-
On Sun, 14 Mar 2010 11:32:01 -0700, Leif Thorsen
>How can I show a range of dates in a pop-up calenda...SelStart Error
I have been using input masks for dates on forms. I usually add code to
force the cursor to the beginning of the text box using SelStart.
Private Sub txtDate1_GotFocus()
Me.txtDate1.SelStart = 0
I created a form and the above field functioned fine. After I added more
controls and code I began to get a Run-time 2185 error -You can't reference a
property or method for a control unless the control has the focus.
Anyone know what causes this or is my form corrupted in some way?
Thanks in advance for any help or insight,
Scott, the only case that comes to mind ...excel office home and student freezes all the time
I purchased office home and student 2007 several months ago. I have Vista on
my computer. I had issues with Word, but was able to fix it. I have had no
reason to use Exce, until now. When ever I open it, it constantly freezes
up, with the little circle spinning. It says all the updates are on my
computer. I have no idea how to fix this issue, and it is very frustrating,
and time consuming trying to fix this issue. Thanks for you help.
Ok guys fairly complicated one here...
I have a single table with 20,000 transactions within it. Each transaction
has a date attached to it.
I have another table which contains 3 fields, a StartDate, a FinishDate and
a WeekNumber. i.e.:
startdate finishdate weeknumber
01/01/2007 08/01/2007 1
What I need to be able to do is take each transactions from the transactions
table and link it to this calendar table to get the weeknumber of when each
How on earth can I produce this?
> Ok ...ComboBox DropDown Size: Design vs Run Time?
I was wondering, what's the reason for specifying the dropdown size of a
combobox at design time?
I'd say it's better to make the size as large as possible to display as
much rows (and columns) without falling of the screen.
Olaf van der Spek wrote:
> I was wondering, what's the reason for specifying the dropdown size of a
> combobox at design time?
> I'd say it's better to make the size as large as possible to display as
> much rows (and columns) without falling of the screen.
Sounds reasonable. Are you having some kind of issue wit...