Excel calculate year of service with different methods

Posted on January 25, 2017 by Wyman W

This Excel tutorial explains how to calculate year of service in Excel using different calculation methods. Excel calculate year of service Having worked for human resources field for some years in different companies, I have seen different systems / companies use different calculation methods to calculate year of service for annual leave entitlement. In this post, I want to summarize how to use Excel to calculate year of service using different methods to help HR professionals. Method 1 - ca...

Access Excel remove text in brackets

Posted on December 11, 2016December 28, 2016 by Wyman W

This Access Excel VBA tutorial explains how to remove text in brackets using custom Function. You may also want to read: Change text color in brackets Extract text in brackets Access Excel remove text in brackets I was inspired to create this post because the HR system I am using (Workday) is very annoying, some data fields are actually a combination of two different fields, the additional data field is displayed in brackets in the prefix. For example, an employee has a English name ...

Excel VBA separate line break data into different rows

Posted on August 31, 2015July 5, 2018 by Wyman W

This Excel VBA tutorial explains how to separate line break data into different rows. You may also want to read: Access Excel remove line break and carriage return Excel VBA delimit Cell value into rows Excel VBA separate line break data into different rows Recently I received a report from a HR system which is claimed to be a standard report. In the report, some data are grouped into one Cell and are separated by line break. I found this report format totally unacceptable. From th...

Peoplesoft HCM Business Unit, SetID, TableSet

Posted on July 16, 2015August 8, 2015 by Wyman W

This Peoplesoft HCM tutorial explains Business Unit, SetID, TableSet. Peoplesoft HCM Business Unit, SetID, TableSet SetID If you look at the Table fields through Query Manager, you will find many Peoplesoft Tables contain SetID field. Tables that have SetID field include Location, Jobcode, Department, Salary Admin Plan, Employee Class, etc. SetID is a grouping for Business Unit in order to restrict or grant access to data within a table. If SetID contains only one Business Unit, the SetID ...

MPF Ordinance in Hong Kong

Posted on March 8, 2015July 16, 2015 by Wyman W

MPF Ordinance in Hong Kong This tutorial explains the core concepts of MPF Ordinance in Hong Kong. All data were updated as at 2015 March, I may not be able to constantly update the Ordinance. MPF Enrollment Permitted Period is the period within which an employer must enroll employees in an MPF scheme. Employment type Permitted Period Non casual employee the first 60 days of employment Casual employee the first 10 days of employment Self employed person the first 60 ...