$$Excel-Macros$$ Re: Urgent Need help on formula.

2009-11-19 Thread RolfJ
This might work for you. Let's assume that the total numbers of minutes is located in cell A2. The following formulae would calculate the number of whole days, hours of next fractional day and minutes of next fractional hour: Number of days (Cell B2): =INT(A2/60/24) -> 22 for your example Hours o

RE: $$Excel-Macros$$ Require help on a condition

2009-11-19 Thread Dave Bonallack
Hi Pooja, Does the attached do what you need? Regards - Dave. Date: Thu, 19 Nov 2009 13:35:28 +0530 Subject: $$Excel-Macros$$ Require help on a condition From: vatspoojav...@gmail.com To: excel-macros@googlegroups.com Hi All, I've attached a file in which, a data is mentioned with the requ

$$Excel-Macros$$ Count of Text

2009-11-19 Thread mahavir
Pls help -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn

$$Excel-Macros$$ Urgent Need help on formula.

2009-11-19 Thread vinod rao
HI Friends, I have a question in excel formula, I have a number which gives total numbers of minuts, example 32269 and it is minutes total. Can excel find numbe of days and hours and minutes in that total. This is very urgent. kindly help Regards, Vr --

$$Excel-Macros$$ Require help on a condition

2009-11-19 Thread Pooja Sharma
Hi All, I've attached a file in which, a data is mentioned with the required solution. If any body can help me in this, it will be of great help. -- Best Regards Pooja Sharma -- -- Some important links for excel us

Re: $$Excel-Macros$$ Plz Urguntly Help needfull

2009-11-19 Thread Sandeep Kumar Maurya
Hi Anil, >From Insert menu goto Define Names (As you do for named ranges) then give the Each name (Anil) the value you want. Then A B 1Anil =indirect(A1) 2Saxena =Indirect(A2) Regards Sandeep On Thu, Nov 1

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-11-19 Thread Dilip Pandey
Hi Umed, Please find the solution attached with this email. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Nov 19, 2009 at 5:56 PM, Umed Singh wrote: > Please attached the correct file here. >

$$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-11-19 Thread Umed Singh
Please attached the correct file here. On 11/19/09, Umed Singh wrote: > Dear All, > > Please find the attached file and solve mu problem with validation. > > Regards, > Umed Singh > > -- Umed Singh -- -- Some im

Fwd: $$Excel-Macros$$ Plz Urguntly Help needfull

2009-11-19 Thread Anil Saxena
-- Forwarded message -- From: Anil Saxena Date: Thu, Nov 19, 2009 at 10:28 AM Subject: $$Excel-Macros$$ Plz Urguntly Help needfull To: Dilip Pandey Cc: excel-macros@googlegroups.com Hi Ayush plz help me Urguntly Plz suggest me how to use formula like these e. g. when i written

Re: $$Excel-Macros$$ Plz Urguntly Help needfull

2009-11-19 Thread Mohit Chadha
I hope this will help On Thu, Nov 19, 2009 at 12:59 PM, Dave Bonallack wrote: > Hi Anil, > Do you want the value in the same cell as the one you write the name in? > If so, do you want the value to replace the name? (ie, "Anil" automatically > changes to "100") > Or do you want the value a