A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
Adding and Subtracting a Time with MilliSeconds by carl
My time comes in like this: 10:39:41:91 10:39:54.01 hours:minutes:seconds.milliseconds. Is there a way to add and subtract times in this format ? Thank you...
May 31st, 2007 10:55 PM
by Erny Go to last post
7 73
adding and subtracting columns by sierra_louise
How do I do the following: Column B (add) Column C (minus) Column D (total of A minus B) example Column A Column B Column C Column D
August 24th, 2006 11:45 AM
by Pete_UK Go to last post
3 39
Adding and subtracting dates by Bjair
I am trying to subtract one date from another and have the answer display as yy/mm/dd. For example: If I subtract 2/18/1985 from 8/1/2006, the answer should...
August 9th, 2006 05:25 AM
by Bjair Go to last post
3 59
Adding and Subtracting in checkbook program by sadasiva
I recently Dloaded from the MS template site an Excel Checkbook spreadsheet program that is supposed to add and subtract credits and debits - i thought this...
June 8th, 2004 05:28 PM
by Lady Layla Go to last post
2 266
Adding and subtracting many columns numbers by WoodyAccess
My column B is entitled "No. in Stock". These boxes contain the quantity of a certain product that we have in stock. My columns E and G are entitled "Used"...
January 2nd, 2007 01:02 PM
by Roger Govier Go to last post
1 57
Adding and subtracting time by Terry Bennett
I have a spreadsheet where I am calculating changes to opening hours in a number of outlets. Columns C to N detail existing hours (ie; Monday Open, Monday...
February 13th, 2007 12:24 PM
by Terry Bennett Go to last post
2 67
Adding and subtraction by Murray
Hi, all i need to do is a value is added to column C adds to the running totlal and if a value is put in column D it subtracts from the running total. Any...
October 7th, 2008 11:57 AM
by Pete_UK Go to last post
2 57
Adding and then sorting data into an already existing Excel 2007 w by courtenaylambert
HI, I've added data (pasted it) into an spreadsheet, and now I'm unable to sort all of the data together. Can anyone tell me why? I had no problems doing...
March 26th, 2010 07:25 PM
by Fred Smith[_4_] Go to last post
2 127
Adding based on cell location by Alex
I would like to add a column based on a specific cell's value. For instance, say I type the number "10" into cell A1. I would then like to add the contents...
January 15th, 2004 04:00 PM
by Frank Kabel Go to last post
1 252
Adding based on multiple criteria by Custard Tart
My spreadsheet has two colums side by side. Column A: contains letters such as GM, GMA, GMQ etc. Column B: contains complete, partial,...
August 18th, 2009 02:03 PM
by Luke M Go to last post
5 91
Adding blank rows between groups of similar names by Justin
I have a spreadsheet that is about 1200 rows long. The first column contains names of funds, and the other columns contain different information about them....
July 6th, 2007 07:28 PM
by Pete_UK Go to last post
2 62
Adding Borders by Wayne
I upgraded from EXCEL 2000 to 2003 and I see that there is LESS Border Options to use. Is there some way I can Import some of those from 200 or add in any way?
June 15th, 2005 01:32 AM
by Wayne Go to last post
2 96
Adding business days to a date by Keith R
I have a spreadsheet with several thousand start dates; in another column I have the number of business days to completion. I need to translate the...
April 16th, 2007 07:31 PM
by Peo Sjoblom Go to last post
2 46
Adding Business Days to Date by Dan R.
How do I add business days to a date to get another date? For example: A1 = 4/08/2004 B1 = 5 Add A1 and B1 to get C1 = 4/15/2004? This is sort of the...
May 17th, 2004 04:52 PM
by Ron Rosenfeld Go to last post
3 315
Adding button to worksheet to refresh pivot table data by Ron
I've created a daily input worksheet and it kicks out the results to a pivot table. I want to create a button on that chart for the user to click on so it...
October 11th, 2007 12:13 PM
by Roger Govier[_3_] Go to last post
1 58
Adding buttons to a new menu bar by Greegan
I am cross posting ( i think ) because the server seems to have an issue with the other newsgroup (possibly) Hello everyone I hope someone can help me...
April 7th, 2006 07:55 AM
by Ron de Bruin Go to last post
1 86
Adding By Color by GR
I have a row of numbers, some black and some blue. Is it possible to set up a formula to look at the entire row and (i) return the sum of only the...
June 7th, 2005 09:00 PM
by N Harkawat Go to last post
3 101
Adding by font colour in Excel by Zakynthos
I have a spreadsheet with values formatted in one column in red and some in black. What function or formula can I use to count only the numbers in red? many...
April 25th, 2007 12:26 PM
by Zakynthos Go to last post
2 85
Adding bytes, gigabytes, and megabytes in Excel by NetTech
I have data in Excel that comes across as Megabytes and Gigabytes (i.e 500 MB, 3 GB, 200 BM, etc). How can I format this data so Excel recognizes these as...
July 3rd, 2007 05:43 PM
by Pete_UK Go to last post
3 73
Adding Calendar to Worksheet by tracktor
I want to add a calender to my worksheet that when a user selects a specific cell the calender will come up, the user can select a date, and it will fill the...
May 18th, 2008 10:50 AM
by Ron de Bruin Go to last post
9 160
Post New Thread


Display Options
Showing threads 2161 to 2180 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.