Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-30-2011, 02:03 AM
gsrikanth gsrikanth is offline i want add  D Column in excel Windows XP i want add  D Column in excel Office XP
Competent Performer
i want add  D Column in excel
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default i want add D Column in excel


Plz find the attachment

how to custom?
how to format cell?
Attached Files
File Type: xlsx 12.xlsx (10.2 KB, 9 views)
Reply With Quote
  #2  
Old 12-30-2011, 03:35 AM
Catalin.B Catalin.B is offline i want add  D Column in excel Windows Vista i want add  D Column in excel Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, România
Posts: 386
Catalin.B is on a distinguished road
Default

you have to be more specific...
you need to add column D to what? You mean a total for column d?
Or formatting is what you dont know?
-select the column, right click on selection, format cells, custom, then in type field, write: m.yy
more on formatting:
http://support.microsoft.com/kb/264372
Reply With Quote
  #3  
Old 12-30-2011, 04:00 AM
gsrikanth gsrikanth is offline i want add  D Column in excel Windows XP i want add  D Column in excel Office XP
Competent Performer
i want add  D Column in excel
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

i mean a total for column d?
Reply With Quote
  #4  
Old 12-30-2011, 04:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline i want add  D Column in excel Windows XP i want add  D Column in excel Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,480
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

So you want to sum the dates in Col D ? The result is a date somewhere in the year 2813 ??
Reply With Quote
  #5  
Old 12-30-2011, 04:37 AM
Catalin.B Catalin.B is offline i want add  D Column in excel Windows Vista i want add  D Column in excel Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, România
Posts: 386
Catalin.B is on a distinguished road
Default

why do you want to add, say: 1.40, which is january 1940, to 3.59, which is march-1959?? the sum wil give 3.99 (march 1999) which is unusable...
Maybe you want to add the number of month only? not years...
place this formula in E1, and copy it to the last row
=IF(ISERR(MONTH(D1));0;MONTH(D1))
to extract the number of month from date
and sum =SUM(E1:E28) in E29 will give you the result of 35 total number of month for the sample posted
Reply With Quote
  #6  
Old 12-30-2011, 05:27 AM
gsrikanth gsrikanth is offline i want add  D Column in excel Windows XP i want add  D Column in excel Office XP
Competent Performer
i want add  D Column in excel
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
why do you want to add, say: 1.40, which is january 1940, to 3.59, which is march-1959?? the sum wil give 3.99 (march 1999) which is unusable...
Maybe you want to add the number of month only? not years...
place this formula in E1, and copy it to the last row
=IF(ISERR(MONTH(D1));0;MONTH(D1))
to extract the number of month from date
and sum =SUM(E1:E28) in E29 will give you the result of 35 total number of month for the sample posted
thanks for reply

you are mistaken

i want add d column values in my excel sheet 6.50+3.50+2.00+3.00=15.00 answer
6.50
0-00

6.50 3.50
0-00

3.50 2.00
0-00

2.00 3.00
0-00

3.00
total 15.00
Reply With Quote
  #7  
Old 12-30-2011, 05:32 AM
gsrikanth gsrikanth is offline i want add  D Column in excel Windows XP i want add  D Column in excel Office XP
Competent Performer
i want add  D Column in excel
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
So you want to sum the dates in Col D ? The result is a date somewhere in the year 2813 ??
The result is 26.83

only add doted value manual

added firstly two value the result is 9.98
Reply With Quote
  #8  
Old 12-30-2011, 06:04 AM
Catalin.B Catalin.B is offline i want add  D Column in excel Windows Vista i want add  D Column in excel Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, România
Posts: 386
Catalin.B is on a distinguished road
Default

your first two entries, which makes 9.98, as you say, came from:
6.63 +3.35, right?
But:
6.63 is just what you choosed to SEE on screen, the number behind 6.63 is 23163, same for 3.35, the number is 12844, you can format this number to be shown in many ways, but the number behind what you see is the same.

You have to read more about excel date/time format.
A good start could be this:
http://www.cpearson.com/excel/datetime.htm
anyway, if you insist to do this type of calculation, you have to extract month and year (last 2 digits, and transform it as decimal number, in order to add it to month)
(Why on earth do you need this??)
the formula in E1, copied down , is:
=IF(ISERR(MONTH(D1));0;MONTH(D1))+VALUE("0,"&IF(IS ERR(YEAR(D1));0;RIGHT(YEAR(D1);2)))

and the sum is 37,12 , not 26,83
Attached Files
File Type: xlsx Copy of 12.xlsx-2.xlsx (11.2 KB, 2 views)
Reply With Quote
  #9  
Old 12-30-2011, 06:11 AM
gsrikanth gsrikanth is offline i want add  D Column in excel Windows XP i want add  D Column in excel Office XP
Competent Performer
i want add  D Column in excel
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

thank Catalin.B
i studied new think today days count from 0-jan-1900
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
i want add  D Column in excel word column irmorteza Word 2 07-05-2011 02:40 AM
i want add  D Column in excel Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM
Column/row reversing in excel pban92 Excel 2 01-26-2011 12:00 PM
i want add  D Column in excel From Excel column to coma saatfj Excel 2 04-15-2010 09:59 PM
i want add  D Column in excel Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft