Change a seconds value into mm:ss
I have a bunch of values in seconds (534.49 seconds, 649.87 seconds..
and so on) and would like to display them in minutes and seconds. I
there an easy way to do the conversion
Message posted from http://www.ExcelForum.com
Divide by 86400 (put 86400 in an empty cell, copy it, select the
values and do edit>paste special and select divide, format custom as [mm]:ss
"guilbj2 >" <<firstname.lastname@example.org> wrote in message
> I have a bunch of values in seconds (534.49 seconds,...Can't open a form
I posted this in the Outlook boards and got no answer. I may have found the
reason. If I open Outlook to the .pst file I can create an appointment. It
is only when trying to connect to Exchange I have a problem. So I think this
may be a server side issue. Another point. My laptop runs Outlook 2k. I just
tried making an appointment in O2K, which I could do. So now I am not sure
if it is server side or not.
When trying to open an appointment form by any method I get the following
message "The form required to view this message cannot be displayed. Contact
Yes it ...Changing Font Characteristics Within a Formula
How do I change the font color and make it bold within a formula? I am
trying to link two different cells with text in them to one cell and I
would like to have the color and font weight changed for just one of
the links. For example...
I want B1 to show 1(black normal font), 2(red bold font)
jdurrmsu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27122
View this thread: http://www.excelforum.com/showthread.php?threadid=467599
What you want is called ...Signatures and formats, Help Please
Here is the situation:
- Outlook 2000 Workgroup Only format to send mail: HTML
- Exchange Server 5.5, provides messages for pop3 and imap: html.
- Outlook Express 6 (POP3 access) sends and receives as html.
all email clients have a png file as signature, inserted with html code.
(<img src= />
a) Outlook 2000 WO, sends email to another Outlook 2000 WO, signature Ok.
b) Outlook 2000 WO, sends email to Outlook Express 6 (or any other
client with pop3 access), signature NOT ok. (appears a red X telling me
that it can't find the file)
c) any other client (not our ...How do I set up a financial planner using Microsoft excel?
How do I set up a financial planner using Microsoft excel?
What have you done so far?
Is there a specific problem that you need help with?
> How do I set up a financial planner using Microsoft excel?
Excel FAQ, Tips & Book List
...how can I exceed the nested if fuction limit #2
I am trying to create a validation for a column based off of the previous
columns value, which reqires many nested if functions, (10 to be exact).
However the limit of 7 nested if function prevents me from being able to do
this. With all the amazing things that excel can do, there has to be some
sort of work-around for this.
Usually the best alternative is to use a Lookup function, however, without
more details its hard to give a fuller explanation.
> I am trying to create a validation for a column based off o...Change Users AD Name
We installed CRM with a domain admin and would now like to change the AD
entry for that user. We would like to know is there any CRM downstream
hazzard in changing that administrator's user name in AD?
Yes. Changing the AD login breaks the tie to AD as it looks at both the
login name and the SID. There are a few options to fixing this, I remember
seeing a KB article recently that outlined how to synch CRM up with this
type of change.
1) Go into Deployment manager and expand User manager
2) Right click on the account in question and select Change Account
3) Choose a new AD accou...setting up O.E. to send and recieve MSN mail
I have a MSN mail account, and want to set up my O.E. to
sent and recieve my mail. I went to "accounts" and did
everything that I was supposed to, and when I tried to
send mail, I got the following two messages:
The service is currently unavailable. Try again later.
', Protocol: HTTPMail, Server Response: 'Service
Unavailable', Port: 0, Secure(SSL): No, Error Number:
Unable to poll for new messages on your HTTP server.
Serve...WMP 12 Video Settings (Brightness/Contrast etc.) Won't Work
I have new Sony CW laptop running Windows 7 (64-bit) with an Nvidia GeForce
GT 230m graphics card.
The problem I have is that I can't adjust the video settings
(colour/contrast/brightness etc.) in Windows Media Player 12 as I am used to
being able to do in previous versions. I use this function all the time and
it is not enough for me to simply change the global settings as I know it
should be possible within Windows Media Player.
I updated the Nvidia driver and downloaded the K-Lite codec pack (too
complicated - didn't know which codecs to adjust) with no resu...Settings area disappeared from Client
Hi, I have been working in Settings area, adding new fields to forms etc and
all was well. I then decided to install the Outlook Client which seems to
have gone well except for when I go back to Internet Explorer and go to
http://crmserver my whole Settings area isn't there anymore , just Workplace,
Sales, Marketing and Service. (I went to server to check my role was still
Systems Administrator and it is) Any ideas on how to get Settings to show up
again would be appreciated.
Sorry,step 13 Restart computer, fixed it.
> Hi, I have been working in Set...Can I change the "white cross" cursor in Excel to another cursor?
I don't particularly care for the "white cross" cursor in Excel. Can it be
changed to another cursor?
Not an option that anyone has been able to alter as far as I can recall.
Gord Dibben Excel MVP
On Tue, 3 May 2005 10:23:01 -0700, "KFEagle"
>I don't particularly care for the "white cross" cursor in Excel. Can it be
>changed to another cursor?
...Office 2008 doesn't install
when I tried to install it said it can't find software to install, just after choosing the install location. what's going on? I have office 2004 installed.
problem solved - I had to change the system language to english before installing!
...How do I change a spreadsheet from English to Spanish?
I'm now working in a bi-lingual facility and need to create several
spreadsheets in Spanish that I already have saved in English. Is there a way
to change the language in an existing spreadsheet?
The formulas will be translated automatically, if the spreadsheet is loaded
into a Spanish version of Excel. There are a few exceptions, like functions
from Analysis Toolpak.
Text cells will not be translated automatically.
Microsoft MVP - Excel
"Steve@bepc" <Steve@email@example.com> wrote in message
news:D5304E1D-637...Conditional Formatting Formula Help Part 2
I am working on a conditional formatting formula that will refer to a
different worksheet that the one it is in, I hope this can be done, so
here's how the formula needs to be:
in cell X2 of worksheet "10 DAY AVERAGES" I need a formula that tests
cell W2 in worksheet "PASTE DATA" to see if it's greater than the 20
day average of cells W2 through D2 in worksheet "PASTE DATA", and if so
I will program a certain highlighting color via conditional formatting,
I would appreciate very much some help with this formula
---------------...You Can Delete a Closed MO
We are running GP Dynamics 10.00.1301 and discovered that an user can delete
a closed MO from the Manufacturing Order Entry screen. This is how it
happens. If you enter the MO #, no not hit [tab] then click Delete it
deletes the MO. The Delete button needs some validation code. I’m going to
open a ticket with Microsoft to report the bug. I'll keep you posted.
i have seen this before and i dont see it as a bug, there is also an
option on the routines section to clear, remove all closed MO's from
The MO entry screen is used to create/update/delete open MOs not
close...Help! Can't boot even to safe mode. Can't re-install OS. 0xc000
I'm hoping some experts are on the discussion group here because I am
getting close to a dead end. I am trying to help a friend restore his
Windows XP installation. It's a real doozie. He has a very expensive CAD
program on it and wants to avoid at all costs wiping the hard drive clean and
losing the program -- for which he has no installation software... (I know,
that was a dumb thing to lose the installation software, but it's been my
experience that it's all too common among the non-geek population...)
--This is a Dell laptop, but there is no re...Conditional formatting with expired dates after current
I am trying to get a cell to turn Red if the date that is in the cell is less
than or equal to the current date. The formula I have in it already is:
This takes the date that I plug into the column before it and just adds 12
months to it. Thanks for any help you can offer.
TODAY() is what you need to compare with,
viz. use as the CF formula for that cell: =EDATE(D2, 12)<=TODAY()
Format to taste, ok out. Success? hit YES below
> I am trying to get a cell to turn Red if the date that is in the cell...Using both Landscape and Portrait page formats in the same sheet.
Would anyone happen to know how to change the formatting of pages in a worksheet to allow the printing of both landscape and portrait pages without having to cut and paste pieces of the data into another sheet.
Any help would be greatly appreciated.
Ps. I know that Word does this task. So is there something available in Excel.
I think what you're trying to do is print several different sections i
the same sheet, some portrait, some landscape.
The easiest way to do this is, for each page or section that you wan
to print, create a "Custom view" All printing information...Drag & Drop Changes in Outlook 2007
Outlook’s Drag & Drop functionality works differently in Office 2007 then it
does in Office 2003.
When I right click to Drag and Drop an E-mail from an OL folder to my
desktop, I am given the option to Move or Copy the Item. When I select Move,
the item is moved to the desktop.
In OL 2003 the moved item will be automatically placed in the OL Deleted
In OL 2007 the item is not automatically placed in the Deleted Items Folder.
How do I restore this functionality in Office 2007?
I am Running Office 2007 SP2 under Windows 7 Ultimate.
...Change Accounting Years
We are changing our accounting year in about two weeks, to be completed
before Dec 31. The company has been using a fiscal year running APR 1
through MAR 31 since installing GP in 1998.
Our current fiscal year, 2008, will be renamed 2007 and run from APR 1
through DEC 31. FY 2007 will be renamed to FY 2006, and so forth back to the
first year in the system. (The actual procedure is to rename the oldest
years first, 1998 ==> 1997, 1999 ==> 1998, etc.)
1/1/2008 will then become the first day in the new accounting year, 2008.
We have made the changes on a test server, using the...Entourage 2008 to Exchange 2003 calendar synch issue -- can it be automated?
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I've been struggling with calendars for a while now with Entourage. So much so, that I brought out my old corporate-provided Dell laptop just for scheduling! <br><br>But, I think I've found my issue. <br><br>I'm running Entourage 12.2.3 and my company does not yet have the latest Exchange server (so the SnowLeopard native support isn't there yet). They might still be on 2003. I'm not sure entirely. <br><br>Here's my issue. Items ...Can't calculate the result if all cash flow are negative in XIRR
I'm using Excel 97. I knew that XIRR only support more than one of
cash flow is positive and negative. But anyone know is there other
workaround to solve it ? Many Thanks
...Conditional Formatting #43
I have a spreadsheet that I need to apply conditional formatting on in
which I have four values: Over 85
For the report cell to be coded a certian way, I can not get Excel to
get past three, all this is one format, any suggestions????
You are limited to three.
Use the default formatting for one of the values and CF for the other three
See Bob Phillips' site for an Add-in which allows many more formats.......30
Gord Dibben MS Excel MVP
On 31 Jul 2006 12:47:08 -0700, eyeman6513_2000@yahoo...Excel cell number formatting should have a significant digits opt.
One should be able to format a cell in Excel so that the number of
significant digits stays constant, no matter how the digits or decimal places
change. You get something like this with the "Scientific" number format, but
it's not as intuitive to look at.
maybe the following helps you:
"Sleep Scientist" <SleepScientist@discussions.microsoft.com> schrieb im
> One should be able to format a...Upload customer info stored in CSV format directly to RMS
We are undertaking a drop ship program. We receive order notification through
program called VendorNet. We also submit tracking info and invoices through
VendorNet. We want to automatically dump customer info from VendorNet to
RMS. We need to be able to upload a .csv file into RMS, and provide a map
of the layout of the order of the fields that the .csv file needs to have to
Any suggestion or a lead to a third party program is very well appreciated.
If you have SQL Server, DTS packages are well suited for this type of thing.