HR Training Payroll

 How to Split Forename and Surname (LEFT, RIGHT, MIDDLE) formula in EXCEL The following formula are useful when you have one cell containing text which needs to be split up. The formula use various text functions to accomplish the task. Each of the techniques uses the space between the names to identify where to split. Finding the Last name when a Middle name is present The formula above cannot handle any more than two names.If there is also a middle name, the last name formula will be incorrect.To solve the problem you have to use a much longer calculation.

 How to Calculate TIME in EXCEL Excel can work with time very easily. Time can be entered in various different formats and calculations performed. See the Time sheet Example below:-  Typing Time When time is entered into worksheet it should be entered with a colon between the hour and the minutes, such as 12:30 , rather than 12.30 Excel can cope with either the 24 hours system or the am/pm system.To use the am/pm system you must enter the am or pm after the time. You must leave a space between the number and the text. Finding the difference between two times You can subtract two time values to find the length of time between. Note:- If the result is not shown correctly,You may need to reformat the answer.Look at the section about formatting further in this worksheet. How To Apply Custom Formatting 1. Click on the cell which needs the format.or Shortcut Key:-  CTRL+ 1 2. Choose the Format menu. 3. Choose Cells. 4. Click the Number tag at the top right. 5. Choose...

  How to Calculation Age and Birth Day in Excel You can calculate  a person age based on their birthday and todays date. The calculation uses the DATEDIF() function   =DATEDIF(C3,TODAY(),"y")  =DATEDIF(C3,TODAY(),"ym")   =DATEDIF(C3,TODAY(),"md") You can put this all together in one calculation, which creates a text version.  ="Age is "&DATEDIF(C3,TODAY(),"y")&" Years, "&DATEDIF(C3,TODAY(),"ym")&" Months and "&DATEDIF(C3,TODAY(),"md")&" Days"

Welcome to HR Training Payroll Here you learn, HR Training, Payroll Management, and MS Office Hindi and English.   Example:-  Salary CTC Structure. Salary Register PF Challan ESIC Challan Labour Law Attendance Management Leave Management Notepad Wordpad Paint MS- Excel MS- Word MS- Power Point MS- Outlook PT-Slab LWF- Slab