![]() We have the following subset of data extract. Calculate the duration of service of employees ![]() There are many ways that you can achieve to calculate the difference between any two dates in Excel.įor this example, we shall discuss how to calculate the length of service of various employees as at a given date, but the concept applies in all the scenarios described above. For most NGOs, it would be needful to know, based on the contractual terms of various consultants, how many months/years are remaining and subsequently, how many employees have their contracts ending, say in the next 3 months, 6 months, and so on. In an automotive industry, you would need to compute how long, say a given vehicle has taken to be serviced. In any working environment, there are various instances where you would be required to calculate the duration between two dates.Ī human resource officer would need to know how long a given employee has worked with the company or the actual age of the various employees for planning purposes.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |