I have data downloaded into Excel that gives the time span in seconds only.
For example, I have a driver at a location for 1 hrs:4 mins:44 secs - the
目前分類:title (4957)
- Nov 03 Mon 2008 20:47
How do I convert seconds (up to 38,000) into HR:MN:SEC?
- Nov 03 Mon 2008 20:47
Disable border double-click navigation in Excel
When you select a cell in Excel 2002 (I believe this is true in other
versions as well) and double-click on the top or bottom border you will be
- Nov 03 Mon 2008 20:47
Fully functional spreadsheets on web?
- Nov 03 Mon 2008 20:47
Dynamic Titles in a Pivot Charts
Folks,
- Nov 03 Mon 2008 20:47
sorting rows into a list
- Nov 03 Mon 2008 20:47
Two cells into one
- Nov 03 Mon 2008 20:47
problem with scatter graph
My problem is that I set up my graphs ahead of time and select the whole
range where the data is eventually filled in. When I look at the graph until
- Nov 03 Mon 2008 20:47
Toggle Chart Series Objects On/Off
Is there a way to use radio buttons (or any other controls or forms) to
display, or not display, individual series of a chart seriescollection? I
- Nov 03 Mon 2008 20:47
Auto Calculation not working
On some documents that we have the Auto Calculation command will
not work, but if we create a brand new document it will work fine.
- Nov 03 Mon 2008 20:47
pivot table field list
How do you display the pivot table field list
- Nov 03 Mon 2008 20:47
Excel Formula's
I am trying to if statements that take information from sheet 1 and transpose
it on to sheet 2. I want to keep the formulas for other worksheets as this
- Nov 03 Mon 2008 20:47
ChartLabeler Questions
I have been using the ChartLabeler from appspro.com that by the way it is
fantastic!!!!!!. in all my charts to add difference kind of labels
- Nov 03 Mon 2008 20:47
Replacing several rows
Hi all...
I have a form that I imported into Excel. There are rows that are repeated
- Nov 03 Mon 2008 20:47
Excel Maps of US
I need to chart shipments to geographic regions in US. Does anyone
have any tips besides purchasing Microsofts Map Point?I wish I knew the answer. it appears there is no way to do this..
- Nov 03 Mon 2008 20:47
Speedy way to create IF Function
Greetings, I am hoping someone knows a trick for completing a LONG if
statement. Here is my statement getting info from 2 fields...
- Nov 03 Mon 2008 20:47
getting a value
- Nov 03 Mon 2008 20:47
Use Excel To Calculate Several ranges within one column
I need to know if this is possible without creating a circular reference.
- Nov 03 Mon 2008 20:47
I Lost my excel password How can I open it?
Could somebody help me to open my excel files they were password proteccted
but I do not remember it.Hi Leo
- Nov 03 Mon 2008 20:47
Replace Error with a Dash
I have a cell with the following formula:
{=AVERAGE(IF(B4:M4lt;gt;0,B4:M4))}
- Nov 03 Mon 2008 20:47
HOw can I paste data into a column with autofilter?
Working on an XLS s/sheet with over 10,000 rows. Have filtered one of the
columns and now need to change that data by pasting from another s/sheet (