subrosumon
Board Regular
- Joined
- Mar 20, 2014
- Messages
- 124
Hi Experts,
Sorry for wastage you valuable time for my critical issues! as a HR staff, i need to calculate actual staying time if he intermittent input in my organization
for example
<tbody>
[TD="width: 348, bgcolor: transparent"] ABC Company
[/TD]
[TD="width: 348, bgcolor: transparent"] from 3 October 2010 to 25 January 2014
[/TD]
[TD="width: 348, bgcolor: transparent"] XYZ Company
[/TD]
[TD="width: 348, bgcolor: transparent"] from 28 January 2014 to 12 December 2015
[/TD]
[TD="width: 348, bgcolor: transparent"] ABC Company
[/TD]
[TD="width: 348, bgcolor: transparent"] from 13 December 2015 to 18 September December 2019
[/TD]
</tbody> Needto calculation
if it is formula it s better or me
Tanks in advance
Sorry for wastage you valuable time for my critical issues! as a HR staff, i need to calculate actual staying time if he intermittent input in my organization
for example
Name of Organization | Period |
<tbody>
[TD="width: 348, bgcolor: transparent"] ABC Company
[/TD]
[TD="width: 348, bgcolor: transparent"] from 3 October 2010 to 25 January 2014
[/TD]
[TD="width: 348, bgcolor: transparent"] XYZ Company
[/TD]
[TD="width: 348, bgcolor: transparent"] from 28 January 2014 to 12 December 2015
[/TD]
[TD="width: 348, bgcolor: transparent"] ABC Company
[/TD]
[TD="width: 348, bgcolor: transparent"] from 13 December 2015 to 18 September December 2019
[/TD]
</tbody>
- How many years, months and days he is working all company (total Experience)?
- How many years, months and days he is working of ABC company?
if it is formula it s better or me
Tanks in advance
Last edited: