$$Excel-Macros$$ overtime calculation in excel

2010-08-29 Thread vaibhav joshi
Hi all please find enclosed sheet of overtime calculation. Please note that duty timing is 6.30 to 4.30 If someone help me ,i will be grateful Regards Vaibhav -- -- Some important links for excel users: 1. Follow u

Re: $$Excel-Macros$$ What is vlook & hlook.

2010-08-29 Thread Ankit Agrawal
thank you sir, but again it is not easy to me yet, But I m trying to understand it. On Sun, Aug 29, 2010 at 7:17 PM, Maries wrote: > Dear Friend, > > Pls. find the attached file.. it will help you to know HLOOKUP and VLOOKUP. > > Regards, > > Maries > > > On Sun, Aug 29, 2010 at 9:48 AM, Ankit

Re: $$Excel-Macros$$ I love excel because.......

2010-08-29 Thread Ayush
Hi Guyzz, Come on ..Please participate in this If you dont respond, It means that you dont love excel. Express yourself !! Thanks to those who responded quickly :) -Ayush Jain Group Manager On Aug 29, 1:26 am, Vinod N wrote: > Excel makes life simple Be it an analysis or dashboard or

$$Excel-Macros$$ Re: Calculation based on changing conditions

2010-08-29 Thread xsrossiter
Thank you both, Michael and Vinod N, for these helpful solutions, Steve. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Li

Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into another two cells

2010-08-29 Thread Bruno Bruno
Hm, for some reason I only received this email after I send the last one. Ashish's solution is much more elegant than mine. Please forgive for sending useless attachments to your emails. On Sun, Aug 29, 2010 at 5:32 AM, ashish koul wrote: > check the attachment if it helps > > On Sun, Aug 29, 2

Re: $$Excel-Macros$$ Rupee symbol on PC

2010-08-29 Thread Dilip Pandey
Hi Ashish, Thanks for the solution. It is good for the old Indian Currency format, but how can we include new Indian Rupee format. Thanks, Dilip Kumar Pandey On 8/21/10, ashish koul wrote: > check the attachment > > regards > > ashish koul > akoul.blogspot.com > > On Sat, Aug 21, 2010 at 6:57

Re: $$Excel-Macros$$ How to Use Vlook with String

2010-08-29 Thread Dilip Pandey
Dear Thakur, I am not sure what you are looking for. Can you elaborate more through a sample file. If you are willing to vlookup the values based on the names, then vlookup will fetch the first value and will ignore the other values which are in bottom. Further to this, I am not sure what are y

$$Excel-Macros$$ Re: Calculation based on changing conditions

2010-08-29 Thread Michael Hayes
Steve, Lets assume that your columns are labeled A, B & C. meaning that cell A2=2, B2=3, C2=5 put this formula in cell C2, =IF(B2="",A2+C1-A1,B2+A2) Copy that formula down. Michael On Aug 28, 12:43 am, xsrossiter wrote: > Hello, > > I am using Excel 2002 SP3 and hope to find a conditional s

Re: $$Excel-Macros$$ Need help to convert date formate

2010-08-29 Thread Vinod N
Hi Vilas, Please find below the macro recorded by me... Sub Date_Format() ' ' Date_Format Macro ' Macro to convert date format- 8/29/2010 by Vinod ' Columns("A:A").Select With Selection Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=

Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into another two cells

2010-08-29 Thread ashish koul
check the attachment if it helps On Sun, Aug 29, 2010 at 1:21 PM, Dave Bonallack wrote: > Hi, > Unfortuneately, your data is not as it appears. On the workbook you posted, > select cell B5. > Look in the formula bar (just above the Column headers) > You will see: *180.5* even though the cell dis

Re: $$Excel-Macros$$ how to separate these cells

2010-08-29 Thread Chandra Gupta
Hi Dear There is problem because cells are in custom format. You should enter this in general format. Chandra Gupta Maurya On Sun, Aug 29, 2010 at 9:51 AM, Ankit Agrawal wrote: > Hello Sir, > > I need help in separate the num & alpha value in the one cell into another > two cells.so i am attach

RE: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into another two cells

2010-08-29 Thread Dave Bonallack
Hi, Unfortuneately, your data is not as it appears. On the workbook you posted, select cell B5. Look in the formula bar (just above the Column headers) You will see: 180.5 even though the cell displays 180.500 kg This is because custom cell formatting in B5 puts in the extra info. Now, in cel

Re: $$Excel-Macros$$ Help in Separate the Num & Alpha in a cell into another two cells

2010-08-29 Thread Ankit Agrawal
I did not get it what does it means? i m newly in excel, so plz decribe it thanks & regards ankit On Sun, Aug 29, 2010 at 10:14 AM, Dave Bonallack wrote: > Hi, > You have custom formatting in the both of your main data columns, which > means that only the numeric value is entered. (Select one o