Cannot Activate MSM Premium on 2nd Computer
I had Money on my computer and my mother board failed. I ended up replacing
my motherboard and C:\ drive. I had no problem reinstalling and activating
on the rebuilt computer.
My problem is that now I want to install Money on my laptop, so I can keep
up with my bills on an extended vacation. I installed Money on the laptop,
but cannot activate it as I get a message that I already have it activated on
the maximum number of computers.
Needless to say that the original computer no longer exists (as such) so I
guess it's counting the original installation and the re-installation as tw...Updating Time & Expense in Portal
I have received some conflicting information on this senerio.....Can someone
We want to have our consultants enter their time and expense online through
the portal. We would like an email to be sent to their project manager
indicating that a time and expense entry is ready to be approved. Upon
receiving the email, the project manager logs in and either approves the time
and expense as submitted or makes a change to the time or expense do to a
miscoding. Can this be done in the portal without returning the timesheet or
expense report to the consultant to make the change??
To c...pinning an @today date and time
I have a 2-column ss. One column is a value and the other is the current
date and time the value was entered. I have set the date and time to appear
only if a value is entered in the neighboring column. I want the date and
time to always be there as the date and time it was when it was created. How
can I pin that value so they don't change every time I open up the ss?
date and time are from @now, not @today. I don't want those values to change
every time I make an entry.
> I have a 2-column ss. One column is a value and the other is...how to sort by number of times played, and last played?
I've been keeping track of the songs played by my band for the
last few weeks, and I want to be able to sort the list by how
often the song has been played, and also by when it was played
last. Currently I have column headings of:
[date] [set number] [song number (within the set)] [song name]
and I would like to get a list [or report, whatever] like this:
[song name] [times played]
song 1����� 26
song 2����� 24
song 3����� 20
song 4����� 20
song 5����� 16
[song name] [last played]
song 1����� [date][set][no.]
song 2����� [date][set][no.]
song 3����� [date][set...How do I convert times from hours to minutes?
I am trying to do a spread sheet where I have a starting time of 10:00am and
an ending time of 11:30am and I want the sum to be total minutes not hours
and minutes. It comes out at 30:00 and I can't figure out how to have it add
in the other hour. Can any one help?
It is incrementing minutes greater than 60 to hours but not showing them. Go
to Format>Cells...>Number>Custom and enter [mm]:ss
the [ ] stop it incrementing. the same with hours to days [h] or [hh]
Microsoft MVP - Excel
Hello, i've got a little problem with time.
A2 = 22:00 ( start time )
b2 = 7:00 ( finish time )
c2 = 1:30 ( breaks )
d2 = 7:30 ( hours worked less breaks )
e2 = hours worked between 6pm and midnight ( formula required please )
f2 = hours worked between midnight and 6am ( formula required please )
g2 = hours worked between 6am and 6pm ( formula required please )
i've looked on the forums and found out how to workout how to calculate d2
but need formulas for e2,f2,g2
i'm sure this will be easy to someone but i'm clueless.
thanks for any help given
Try this in E...Changeing columns in 'list pane' while playing songs.
When showing the 'list pane' during play, is it possible to change the order
of the columns? Or even delete some of the columns, like 'rating'?
What version of WMP and Windows?
Right-click one of the columns, and select Choose Columns. It sounds
like that's what you're looking for.
Tim De Baets
> When showing the 'list pane' during play, is it possible to change the order
> of the columns? Or even delete some of the columns, like 'rating'?
...Active Directory Users & Computers
We upgraded to Exchange 2003 from 5.5 running as a member
server of our domain. On the Exchange box, I can go into
ADU&C and add a new user, doing so the wizard asks me if I
want to create a mailbox at the same time. However when
I'm on our Domain Controller, I don't get ask the
question, a mailbox does not get created and I have to add
it manually at a later time. The Domain controller does
not show any Exchange information in the property sheets.
What did we do wrong? How can I add exchange properties to
the domain controller?
Install the Exchange System Manager on the ...XL97: Application.On time / Protection?
I am trying to create a workbook which I would like to leave open 24 hours a
day, seven days a week.
The worksheet is button operated. I have protected objects, cells with
passwords, disabled formula bars etc.Is there any way that I can make the
menu bar inoperative and also stop the workbook being closed? I don't want
the users to operate anything else but the buttons.
I have created "application.ontime" to run at a certain time. If I run the
code manually it works, how can I get the code to run at say 08.00hrs
everyday if the program is always on?
Thanks very much
I need to create a chart that compares two sets of data. One set is gathered
in 1/2 hour increments and the other data is gathered in hour increments.
The data ranges from 0 to about 600. The data is a numeric count. The times
are military times so there is no am or pm to worry about. I can plot the
data on two axis if it is needed. Please let me know of the best way to do
I would first suggest grouping both sets of data in a comparative fashion.
For example, convert the totals from the one-half hour increments into one
hour totals. Or, convert both sets ...media play goes away when playing cd/dvd
acts like it starting then disappears.... plays installation disks etc...
...Excel 2007 "Document not Saved" to Network Share 2003
When opening a document from a Shared network drive (MS Windows 2003 Server)
with Excel 2007, The document opens. after making a change I get the
compatability message and continue at which point the message "document not
saved" pops up.
This link did not help
Does Excel 2007 have a problem?
I'm having the same issue on a couple of XP machines with Office '07
installed. I've read several articles that say to remove update KB980232. I
removed this update but still no luck. I think a few more updates need to be...Time-based forwarding???
I have a system that needs to be able to send emails to certain groups of
people. During the daytime the emails should go to the managers, but after
office hours and on the weekends the emails should go to the guards on duty.
Is there a way to have emails forwarded to the correct group base on date
If mailboxes are on the same server/routing group, there's no way to send
messages to different people.
One way would be to send the message to a distribution list and change the
group memberships using a script. Schedule the script to change who gets
emai...I want to add the Times
I want to add the Times in many cells ? How to do that
an hour is 1/24 of a day. So.....
"Jambar" <email@example.com> wrote in message
> I want to add the Times in many cells ? How to do that
> I want to add the Times in many cells ? How to do that
Look up the date/time format for cells in Excel help. You can also use
the NOW function if you want the current time.
...Timecard: convert time h:mm to number (example 8.75 hrs) to add totals
I want to take a cell that says =min(c4-b4-h4,8/24)
This cell actually shows my regular hours as 8:75.
I want to convert the figure 8:75 to a number 8.75.
This will allow me to add the numbers across the board.
Can anyone help me to do this?
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Does it *really* show 8:75? In that case you've got something
seriously weird going on.... I suspect it's actually 8:45.
In any case, XL stores times as fractional da...Problems with time
I reinstalled my Computer (Outlook 2007 and Windows XP tablet) and took
the old pst file into the new installation.
Now all events are displayed 8 hours to early on my calendar and my
emails show an arrival time of 8 hours too late.
Please help. What can I do?
Did you check the time zone on the new computer and verify it is correct?
Was the old computer using the same zone?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Ti...Including two data sets with slightly different time stamps
I collected data with two instruments at the same time.
One instrument was collecting data every 0.5 seconds and
the other was collecting every two seconds. I want to plot
the two data sets on the same x-axis to compare their
performance. Excel does not recognize the two time periods
are the same just different measuring frequencies. Any
help would be appreciated.
The use a XY Scatter chart should fix the problem -- as long as you
plot both x and y values.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office product...XL2007: Ribbon commands greyed-out after playing a macro
In XL2007, the ribbon commands are greyed-out after playing a macro, at
least this has happened on my computer time after time (Vista Home Prof
Any thoughts on this?
Already greyed out on opening the file, which occurs as Read-only
automatically. Propably because it is an .xlsm file. For this, refer to my
other question in this group: "XL2007: Read-only automatically applies to
"Peter" <firstname.lastname@example.org> schreef in bericht
> Hi ther...Extracting time
I want to create a spread sheet that will extract time blocks. I have a
manager that is having trouble with time cards. I want her to be able to
enter the hours worked for example 1900 to 0730. I need Excel to figure that
1900 to 2300 is four hours on the evening shift, 2300 to 0700 is 8 hours on
the night shift and 0700 to 0730 is one half hour of overtime on the day
shift. I will put each shift in a separate column. So how to I formulate the
basic question? Thank you. Hopefully I am clear enough, if not please let me
This might help you in the right direction!
http://w...Playing with dates
Rite here I go, I want to automatically add today�s date in a cell,
which I have not done in so long I have forgotten.
Then from using this date I want to be able to search an entire row of
dates and find out if any dates in the row are older then 2 years, if
there is any date that is older then 2 year for it to say yes or
Please can someone help me this has been battering my head for days
johncouzins's Profile: http://www.excelforum.com/member.php?action=get...network name changes on its' own
I have an internet connection through my local cable company. I only use a public wireless connection when I travel each week and stay at a hotel. Usually my home network name is Network 4 at home. I don't think I named it that when I got thid HP computer 1 year ago.....but that has always been the name of the network. Every couple of days when I logon on at home (I don't use wireless at home) my Network connection changes. Some days it will be Network 4....sometimes Network 2.....sometimes just Network. I am not a computer wh...How do I include non working time in duration?
Hi I am setting up a project and in the duration column I want to show the
total number of days required for the project including non working days -
i.e if a task takes 6 days and starts on a Monday, if Sat and Sun are non
working the task is finished on the following Monday but has taken 8 days to
complete (including non working time).... Does anyone know how i can show
You could insert a custom field (Text or Number, with the formula:
But this DateDiff function rounds down to the lowest entire number.
G�rard Du...Cache Rebuild Every Time
Every single time I open my copy of Visio (2002 Pro on XP Pro machine) it
rebuilds the cache, which takes forever.
Why is it doing this every time and how can I stop it/
Is this previous thread any help?
"Keith" <@.> wrote in message
> Every single time I open my copy of Visio (2002 Pro on XP Pro machine)
> rebuilds the cache, which takes forever.
> Why is it doing...Calculate a projected finish time from start time
Hopefully someone can help me please.
Ok heres the problem I have a start date and time and need to add hours to
this to display a projected finish time.
I have done this with (start date + hours) and this works, but if i need to
add hours over 24 it will not allow me.
Im using a general date field at the moment.
Thanks got it working fine now.
Ofer Cohen wrote:
>Check help on the function DateAdd and the options you have in it
>e.g: for adding houres
>> Hopefully someone can help me please.
>[quote...play films and pictures freeze anda restart after 10 minutes
as object videos and pictures start playing after 10 minutes, when i select
video don't start playing, only after 10-15 minutes suddenly video start....
update codecs and operative system... what's the problem? :(
Thanks in advance, regards.