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...
Read More
Book 7 – Human Resources
Access Excel remove text in brackets
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 ...
Read More
Excel VBA separate line break data into different rows
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...
Read More
Peoplesoft HCM Business Unit, SetID, TableSet
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 ...
Read More
MPF Ordinance in Hong Kong
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 ...
Read More