Insert date and time into cell with existing text
Question: I maintain an issues list in Excel. One column contains notes. I'd
like to somehow enter today's date (or today's date and time) into a cell
with existing text.
The eventual output would look like this (all in one cell)
08/20/07: some update about the issue. 08/18/07: some earlier update about
Microsoft MVP - Excel
"bam" <firstname.lastname@example.org> wrote in message news:u4J%23MG26HHA.5360@TK2MSFTNGP03.phx.gbl...
| Question: I maintain an issues list in Exc...Averaging Time
I have data that looks like the following:
I would like to learn a formula that will round the time to the top and
bottom of the hour using the 15 and 45 as the break point. For example
3:09:15 to 3:00. 17:39:10 to 17:30.
Thanks for the hedlp.
=MROUND(A18,TIME(,30,)) and format the cell accordingly.
If you have problems with the MROUND function, look it up in Excel help.
"Jim" <Jim@discussions.microsoft.com> wrote in message
news:E5FACE1B-C1BF-412B-8CB6-7AE1C24F6...Convert number in time
I would like to convert numbers in time but I don't know how.
Ex. in cell A1 I have 107.74 - and I would like to appear this in
time, precisly 00:01:38.
The 107.74 I got with this
The obtained value 107.74, I would like to retransform in time, which
is the formula, or what I have to do?
Megadata's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14879
View this threa...Any quick key to insert current Date and Time?
Use Ctrl+; for the date and Ctrl+: for the time.
Thx a lot!
> Hi Philip,
> Use Ctrl+; for the date and Ctrl+: for the time.
...calc difference in times in different time zones
Is there a way to calculate (subtract) times in different time zones? eg leave baltimore @ 10:35, arrive Dallas @ 13:05 and yeild a time of 3:30
Steve <email@example.com> wrote:
> Is there a way to calculate (subtract) times in different time zones?
> eg leave baltimore @ 10:35, arrive Dallas @ 13:05 and yeild a time of
Sure. One way is to convert the times to UTC and subtract.
...Opportunities and email in BCM
I am trying to find a way to link emails with opportunities. Is there a way
to do this?
Also, I read that there is a newsgroup dedicated to BCM, but I don't see it
when I search for it through my NG reader.
Also, BCM slows down Outlook. Any way to address this?
The BCM newsgroup is microsoft.public.outlook.bcm. Do a search in Outlook
Express. If you don't see it, it's possible that your ISP doesn't carry that
group. You can try to just use the news server msnews.microsoft.com and see
if it apears then.
You can't link emails with Opportunities directly...Removing Dialog Item at Run Time
Is it possible to remove a Dialog item from a Dialog at run time?
This code does not work, but I don't know why:
pl_wnd.Attach( hWndCtrl );
> Is it possible to remove a Dialog item from a Dialog at run time?
> This code does not work, but I don't know why:
> BOOL CMyDialog::OnInitDialog()
> HWND hWndCtrl;
> CWnd pl_wnd;
> GetDlgItem(IDC_REMOVE_THIS_CHECK...RMS Time Clock and Departments
Is anyone aware of a third party addition to Store Operations to add
departments to the cashier and also the timeclock feature? This company
would find the timeclock by department very beneficial.
If your cashiers don't move around a lot, you could work around the
limitation by assigning cashiers numbers based on departments? That way you
could sort or filter reports based on department.
sporting goods cashiers 2001, 2002
housewares cashiers 3001, 3002
Then filter a report for sporting goods cashier > 2000 and <3000
"Kathy" <...time-sheet record with over 24 hours
I want ot create a time sheet for my employees where I can have the first
column be the start time, and the second be the end time, with the ability to
start at 10pm and finish the shift at 8am, which is over the 24 hour mark.
Then have the hours totalled in the third column, with a subtotal for each
week, and total for two weeks. My current dilema is where the hours go over
the 24hour mark in the same day and getting the total of hours worked for
You might get some help from here:
> I want ot ...closed opportunities
want to include closed opportunities in pipeline and forecast reports. any
I am getting error after i am adding new opportunity.
Is someone has any idea why I get this error ?
MSCRM Application Error Report:
Error Message: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code
...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 - firstname.lastname@example.org
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
<email@example.com> wrote...Coordinated Universal Time
I need to use coordinated universal time to calibrate timers at work and
would like to use an excel spreadsheet to record the times. Is there a way
to have excel go out on the web and download the coordinated universal time
from a web site? I can not use the computer time as it is not traceable to
I don't care if it has to be done via a macro.
Thanks for any help you can provide.
See posts from David Peterson And Dana DeLouis (posts 10 & 12) in the
"David M. Alexander"...Anomally in the real time behavior
I use MFC and VS ver. 6.0. Eveything works fine until at a certain moment I
add more variables to controls in a dialog box. Any more variable will cause
anomally in the real time behavior of the application (it uses real-time
Some more information:
1. Its a big application - the exeutable relaease is around 2 mbytes and has
2. In the debug version there are no problems.
Can someone advise please?
Thanks in advance
What do you mean saying "I add more variables to controls in a dialog box"?
And what kind of anomally does occur?
> ...Navigate back from Order to Quote to Opportunity
CRM3.0 stores emails in the History of the related entity (Opp, Quote,
Order). When viewing the emails under e.g. Quote or Order xyz we often need
to view the emails under the corresponding Opportunity xyz. Currently there
is no possbility to jump 'back' from Quote or Order to the Opportunity. You
have to go to Sales/Opportunities, type xyz in the Lookup box, click on
Opportunity xyz and then on History.
Navigating 'forward' from Opportunity to Quote or Order is no problem; these
entities are shown in the left hand pane. Any reason why Opp and Quote cannot
be shown in th...Adding up if over/less than a time
I am really new to excel and starting to love it, but I have come stuc
and would really like some guidence.
I have made this sheet for work where it keeps track of all of ou
hours worked and the basic idea is you put in the time started an
finished and at the end of the week it will add up how many hours yo
have worked and after that, if the figure add's upto more/less than th
time speicfied then it will say owed/owing and the amount.
I have asked on other places and nothing has caught my eye appart fro
this one guy but it's causing me some problems and I don't like how h
has done...Royal Cruise Matrix Is Now In Pre-Launch, Ground Floor Opportunity!
A New Program has just Pre-Launched - Royal Cruise Matrix
This is Your Opportunity to Get In at the Beginning of Something that will
Things you need to know -
- Why Royal Cruise Matrix will EXPLODE in Growth - and draw the masses
better than any other similar kind of program -
Affiliated with Royal Caribbean Cruise Lines
-> MAJOR Name Brand Affiliation = MAJOR Credibility
Lowest Price Point of all the "Board" Programs - Only $100
Highest Pay Out of all of the Board-System Programs - - - -
The ONLY 3-Board System - The 3rd Board Pays out $25,000.00
$10,000 Matching B...How to delete an opportunity
After testing our new CRM we want to go live with it. While cleaning all
entries and deleting all testopportunities i figured out, that some
opportunities can't be deleted. It seems that these are the ones where a
contract is linked to. But I neither can delete a contract nor a opportunity.
Does anyone has an idea how to do that?
For statistics and reports this would be helpfull.
> After testing our new CRM we want to go live ...Plse help....! Incoming eMails connect to the wrong opportunity
Can somebody explain the logic behind the eMail tags, and how the system
connects incoming email?
We have many incoming eMails that connect to the wrong entity.
Consider the following scenario I see happening here:
1) User1 creates new mail regarding Opportunity ABC and changes the sender
to the queue Presales and it gets tag CRM:1234
2) A reply with tag CRM:1234 arrives in the queue Presales and is
automatically connected to Opportunity ABC
So far so good....
3) User1 creates new mail regarding Opportunity XYZ and sends from her own
username and it gets tag CRM:1234 (same tag as before!)
...calculate swim times
How can I track swim event times - mm:ss.ms format? I need to go two digits
deep in the MS format. This is to be used to track swimmer's times and
Thank you all for your time and help.
Format the cells with
In article <46dGc.9460$Bv.firstname.lastname@example.org>,
"saladbar" <email@example.com> wrote:
> How can I track swim event times - mm:ss.ms format? I need to go two digits
> deep in the MS format. This is to be used to track swimmer's times and
> chart progre...Time Problem
My Emails are appearing in my Inbox one hour later than the actual time.
I have tested this by sedning myself a message from an external account, and
it arrived saying it was received one hour before it was sent.
Done that and both are set correctly.....
Anyone from Microsoft got any answer as to why my Emails are showing up in
advance. The Email headers look okay.
"DL" <address@invalid> wrote in message
> Ensure your PC time is set correctly, then check in Outlook, under
> calendar options ...Exception "The operation has timed out" cuming when inserting data from XML file
I am facing a problem when inserting data into database from a remote XML,
i am using XMLTEXTREADER....
System.Net.WebException was caught
Message="The operation has timed out."
at System.Net.ConnectStream.Read(Byte buffer, Int32 offset, Int32
at System.Xml.XmlRegisteredNonCachedStream.Read(Byte buffer, Int32
at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32&
at System.Xm...Help, How can I deduct time for a timesheet?
I am currently working on a timesheet and its urgent that I can sort
something out today. we work on a flexi basis this lady has a contracted
hours of 14:48 hours a work and she worked 12.21 hours last week but it
doesn't seem to like to deduct time I think it should be -2.27 (2 hours 27
minutes) but it just comes up ############# I don't think it likes the
minutes????? It works ok if she has worked over her contracted hours. Can
anyone help me please. Thanks
The # signs indicate that the column in which the cell with your result
displays is formatted too narrowly to s...Date and time calculations
I have a problem with a formula in wich I like to add up an amount of
hours to a date/time value.
Please find below an example of what I am trying to do.
Value A1: 15/03/2005 22:00 (dd/mm/yyyy hh:mm)
Value A2: 5 (hours)
In cel A3 I would like to get the value of A1+A2 (result 16/03/2005
Can someone suggest what formula I must use?
Thanx very much!
Format the way you like. (5 hours is 5/24ths of a day.)
> I have a problem with a formula in wich I like to add up an amount of
> hours to a date/time value.
>...Time format in code
The code below works for what i want, BUT !!
In the worksheet "Lists" i want the 1st combobox to show the values as
hh:mm but am getting the display as decimal, where do i format the
code below to show "hh:mm"
Any help please!!
Private Sub UserForm_Initialize()
Dim cPart As Range
Dim ws As Worksheet
Set ws = Worksheets("Lists")
For Each cPart In ws.Range("A1:A12")
.List(.ListCount - 1, 1) = cPart.Offset(0, 1).Value
For Each cPart In ws.Range("B1:B7")