Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread >>Excel Beginner<
Hi Jocky, I have been given to simple way solution. Please find the attachment. -- *Regards,* * * *Excel Beginner* On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote: > Hi Team, > > I have attached one excel sheet in wich i need to set the formula for the > person for the entir

Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread Anoop K Sharma
Hi Jocky, Made changes in sheet removing validation to show up the values there. Find attached the updated one. On Fri, Jan 4, 2013 at 8:38 PM, Anoop K Sharma wrote: > Hi Jocky, > > Formula's been written in validation rule which will restrict any entry > other entry except 9:00:00 for Mon-Th

Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread Anoop K Sharma
Hi Jocky, Formula's been written in validation rule which will restrict any entry other entry except 9:00:00 for Mon-Thu and 12:00:00 for Sat - Sun. Try to write something there, you'll get error prompting to enter valid values. On Fri, Jan 4, 2013 at 7:11 PM, ashwani agnihotri < ashwani.agniho

Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread ashwani agnihotri
please see if this helps... On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta wrote: > Hi Anoop, > > There is No formula in the attached sheet, :( > > On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote: > >> Hi Jocky, >> >> Please find attached with solution. >> >> Regards, >> Anoop >> Sr. Developer

Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread jocky Beta
Hi Anoop, There is No formula in the attached sheet, :( On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote: > Hi Jocky, > > Please find attached with solution. > > Regards, > Anoop > Sr. Developer > > > On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote: > >> Hi Team, >> >> I have attached one

Re: $$Excel-Macros$$ Need Help for formula

2013-01-04 Thread Anoop K Sharma
Hi Jocky, Please find attached with solution. Regards, Anoop Sr. Developer On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote: > Hi Team, > > I have attached one excel sheet in wich i need to set the formula for the > person for the entire week.i.e is if one person is working form Mon to Fri >

$$Excel-Macros$$ Need Help for formula

2013-01-04 Thread jocky Beta
Hi Team, I have attached one excel sheet in wich i need to set the formula for the person for the entire week.i.e is if one person is working form Mon to Fri it should mark 9:00 and when same person working on Sat & Sun it shoud mark the time as 12:00 Please help me on this -- Join official Fac

Re: $$Excel-Macros$$ >> Need help for formula

2012-03-17 Thread Shaikh Iqbal
Aamir, Thx for both gr8 people. ( Norain / Aamir ) Rgds, Iqbal Shaikh On 17 March 2012 10:10, Aamir Shahzad wrote: > Another soluction > > Aamir Shahzad > > On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI > wrote: > >> >> >> On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal wrote: >> >>> Hi,

Re: $$Excel-Macros$$ >> Need help for formula

2012-03-16 Thread Aamir Shahzad
Another soluction Aamir Shahzad On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI wrote: > > > On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal wrote: > >> Hi, Friends >> >> >> Go through attachment, need your help for formula. >> >> >> >> Thx & Rgds, >> >> Iqbal Shaikh >> -- >> FORUM RULES (986+ me

Re: $$Excel-Macros$$ >> Need help for formula

2012-03-16 Thread NOORAIN ANSARI
On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal wrote: > Hi, Friends > > > Go through attachment, need your help for formula. > > > > Thx & Rgds, > > Iqbal Shaikh > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Pl

$$Excel-Macros$$ >> Need help for formula

2012-03-16 Thread Shaikh Iqbal
Hi, Friends Go through attachment, need your help for formula. Thx & Rgds, Iqbal Shaikh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advic