Re: $$Excel-Macros$$ Help to Calculate Half day leave in Attendance

2013-01-29 Thread hemanath dhanasekar
Use the following formula or more clarity find the > attachment. > > =COUNTIF(*C3:AG3*,"H")*0.5 > > > > > > > > -- > *Regards,* > * > * > *Excel Beginner* > On Tue, Jan 29, 2013 at 9:51 PM, hemanath dhanasekar > wrot

Re: $$Excel-Macros$$ Help to Calculate Half day leave in Attendance

2013-01-29 Thread hemanath dhanasekar
ltaneously "No Of Days Present" should be added up by 0.5. On Tue, Jan 29, 2013 at 2:39 PM, अनिल नारायण गवली wrote: > SEE THE ATTACHED SHEET > > WARM REGARDS, > GAWLI ANIL > > On Tue, Jan 29, 2013 at 1:52 PM, hemanath dhanasekar > wrote: > >> Experts, >

$$Excel-Macros$$ Help to Calculate Half day leave in Attendance

2013-01-29 Thread hemanath dhanasekar
Experts, Help me in providing a formula to calculate the Half day in the attached Attendance Tracker. If I enter H in the column the Half day column should add up by 0.5 and No of days present column should reduce by .5. Thanks Hemanath.D 9176656647 -- Join official Facebook page of this forum

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

2012-07-30 Thread hemanath dhanasekar
, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar wrote: >> >> Friends, >> >> Can any one help me in providing Employee Attendance tracker format with >> Employee utilization in Excel? >> >> -- >> Thanks >> Hemanath.D >> >> >&

$$Excel-Macros$$ Employee Attendance Tracker with Utilization - Format

2012-07-30 Thread hemanath dhanasekar
Friends, Can any one help me in providing Employee Attendance tracker format with Employee utilization in Excel? -- Thanks Hemanath.D -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Fo

Re: $$Excel-Macros$$ Re: Automatic Email from Excel

2012-06-28 Thread hemanath dhanasekar
Thanks Lalit On Thu, Jun 28, 2012 at 3:51 PM, Lalit_Mohan wrote: > > Hi Hemanath > > Hope it helps you > > 'First add Tool -> Refrence -> Microsoft Outlook 12.0 object library > Sub ExportEmail() > Dim olApp As Object > Dim olMail As Object >

Re: $$Excel-Macros$$ Automatic Email from Excel

2012-06-28 Thread hemanath dhanasekar
mp; "Please find the >> attached Report" & " Thanks " & vbCrLf & vbCrLf & vbCrLf & "Regards" & >> vbCrLf & " Noorain Ansari" >> .Display >> End With >> End If >>

$$Excel-Macros$$ Automatic Email from Excel

2012-06-28 Thread hemanath dhanasekar
Friends, I have an excel spreadsheet with dates updated on it, all I need is that the system should automatically send an Email to the specified email address automatically by picking up that particular date. Ex: Date:Subject To 29/06/2012 Renew your

$$Excel-Macros$$ SLA and Daily Productivity Tracking sheet for BPO

2012-01-12 Thread hemanath dhanasekar
Hey Friends, I am Hemanath working in a Leading BPO as Team Leader, I am new to this industry and I need your help folks Can anyone help me in sharing the SLA and Productivity Tracking sheet used in BPO...??? -- Thanks Hemanath.D -- FORUM RULES (986+ members already BANNED for violation) 1)

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-11 Thread hemanath dhanasekar
tx dude its rocking [?] -- Thanks HemanatH. On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh wrote: > *Hi Guyzzz* > * > * > *I found a great tool on internet.* > *You can control Window Media Player using this Excel based tool.* > *If you have tools like these, kindly share with the group

$$Excel-Macros$$ Help me in calculating weighted mean

2010-02-02 Thread hemanath dhanasekar
Hey Group, Hope all doing well, can any one help me in calculating Weighted mean for the attached file Thanks HemanatH -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links